Google Professional-Cloud-Database-Engineer 問題集

質問 1：
Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database.
Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us- central1 and the backup region of us-east1. What should you do?
A. Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-east1-b.
Create a read replica in us-central1-b.
B. Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-west1-b.
Create a read replica in us-east1-c.
C. Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-east-b.
Create a read replica in us-east1-c.
D. Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-central1-b.
Create a read replica in us-east1-b.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster- b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?
A. Use the default app profile with multi-cluster routing.
B. Use the default app profile with single-cluster routing.
C. Create a custom app profile with multi-cluster routing.
D. Create a custom app profile with single-cluster routing.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?
A. Use Database Migration Service to migrate your database.
B. Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.
C. Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.
D. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Your team is building an application that stores and analyzes streaming time series financial data. You need a database solution that can perform time series-based scans with sub-second latency. The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?
A. Use Firestore.
B. Use BigQuery.
C. Use Bigtable
D. Use Cloud Spanner.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?
A. Use Database Migration Service to connect to your on-premises database, and choose continuous replication.
After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.
B. Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL.
Schedule downtime to run each Cloud Data Fusion pipeline.
Verify that the migration was successful.
Re-point the applications to the Cloud SQL for MySQL instance.
C. Pause the on-premises applications.
Use the mysqldump utility to dump the database content in CSV format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.
D. Pause the on-premises applications.
Use the mysqldump utility to dump the database content in compressed format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?
A. Use Cloud Audit Logs to verify the status.
B. Check the cloudsql.googleapis.com/postgres.log instance log.
C. Use the Google Cloud Console.
D. Perform the gcloud sql operations list command.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?
A. Set up Cloud Composer, and create a task to export the table daily.
B. Use Cloud Scheduler and Cloud Functions to run the daily export.
C. Create a streaming Datatlow job to export the table.
D. Run the cron job on a Compute Engine instance to continue the export.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You currently have a MySQL database running on Cloud SQL with a read replica in a different zone for non- mission critical analytics workloads. You want to enable high availability (HA) for the analytic workloads while keeping costs low. What should you do?
A. Create a new MA Instance in a different region than the primary.
B. Create a new HA instance in the same zone db lie primary.
C. Enable HA on the current read replica.
D. Increase the size of the read replica Instance and enable MA.
正解：C

質問 9：
Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7.
You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?
A. Create a read replica, and then use the mysqldump utility to export each table.
B. Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
C. Use Cloud SQL serverless exports.
D. Use the mysqldump utility on the primary database instance to export the backup.
正解：C
解説: (Topexam メンバーにのみ表示されます)