Google Professional-Cloud-Database-Engineer 問題集

質問 1：
Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?
A. Migrate to Compute Engine.
B. Migrate to Cloud SQL for PostgreSQL.
C. Migrate to Google Kubernetes Engine (GKE).
D. Migrate to Cloud SQL for SQL Server.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?
A. Migrate applications and Oracle databases to Compute Engine.
B. Migrate applications to Cloud SQL.
C. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
D. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage.
What should you do?
A. Create one regional Cloud SQL instance with a read replica in another region.
B. Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.
C. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
D. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?
A. Use Cloud SQL federated queries.
B. Develop a custom data replication service to send data into BigQuery.
C. Use Database Migration Service to replicate tables into BigQuery.
D. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?
A. Create a clone database from a read replica database, and restore the clone into a different zone.
B. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
C. Create a clone database from a read replica database, and restore the clone in the same region.
D. Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer data. Youwant to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?
A. Apply an instance data management pattern.
B. Apply a database data management pattern.
C. Apply a table data management pattern.
D. Apply a schema data management pattern.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do?
(Choose two.)
A. If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
B. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
C. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
D. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
E. If the corruption is significant, use import and export.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on-premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application changes, and supports change data capture (CDC). What should you do?
A. Use the native export and import functionality of the source database.
B. Use Database Migration Service.
C. Create a database on Google Cloud, and use database links to perform the migration.
D. Create a database on Google Cloud, and use Dataflow for database migration.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day.
Theapplication team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?
A. Isolate the data analysts and operations user groups to use different Bigtable instances.
B. Add more nodes to the Bigtable cluster.
C. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
D. Use Key Visualizer for Bigtable.
正解：D
解説: (Topexam メンバーにのみ表示されます)