Google Professional-Cloud-Database-Engineer 問題集

質問 1：
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?
A. Restore the Cloud SQL instance from the automatic backups in another zone in region 1.
B. Restore the Cloud SQL instance from the automatic backups in region 3.
C. Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.
D. Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?
A. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.
B. Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.
C. Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.
D. Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?
A. Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.
B. Shut down your existing Cloud SQL for MySQL instance, and enable HA.
C. Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.
D. Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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 メンバーにのみ表示されます)

質問 5：
You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?
A. Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
B. Create a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.
C. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
D. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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 メンバーにのみ表示されます)

質問 7：
Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hot-spots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)
A. Promote high-cardinality attributes in multi-attribute primary keys.
B. Use an auto-incrementing value as the primary key.
C. Normalize the data model.
D. Promote low-cardinality attributes in multi-attribute primary keys.
E. Use bit-reverse sequential value as the primary key.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?
A. Set up Traffic Director.
B. Set up Serverless VPC Access.
C. Set up Private Service Connect.
D. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?
A. Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.
B. Set up all read replicas in the same region as the primary instance with synchronous replication.
C. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
D. Set up all read replicas in a different region using asynchronous replication.
正解：C
解説: (Topexam メンバーにのみ表示されます)