Google Professional-Cloud-Database-Engineer 問題集

質問 1：
Your company's mission-critical, globally available application is supported by a Cloud Spanner database.
Experienced users of the application have read and write access to the database, but new users are assigned read-only access to the database. You need to assign the appropriate Cloud Spanner Identity and Access Management (IAM) role to new users being onboarded soon. What roles should you set up?
A. roles/spanner.databaseUser
B. roles/spanner.backupWriter
C. roles/spanner.databaseReader
D. roles/spanner.viewer
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.
What should you do?
A. Use gcloud sql instances promote-replica <PrimaryInstanceName>.
B. Use gcloud sql instances failover <PrimaryInstanceName>.
C. Use gcloud sql instances failover <ReplicaInstanceName>.
D. Use gcloud sql instances promote-replica <ReplicaInstanceName>.
正解：B

質問 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：
You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?
A. Start the original primary instance and resume replication.
B. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
C. Verify that the new replica is created automatically.
D. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Your team uses thousands of connected IoT devices to collect device maintenance data for your oil and gas customers in real time. You want to design inspection routines, device repair, and replacement schedules based on insights gathered from the data produced by these devices. You need a managed solution that is highly scalable, supports a multi-cloud strategy, and offers low latency for these IoT devices. What should you do?
A. Use MongoD8 Atlas with Charts.
B. Use Firestore with Looker.
C. Use Bigtable with Looker.
D. Use Cloud Spanner with Data Studio.
正解：A
解説: (Topexam メンバーにのみ表示されます)

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

質問 7：
You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead. What should you do?
A. Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.
B. Create a Cloud Composer instance, and create a directed acyclic graph (DAG).
C. Create a VM in Compute Engine, and run a cron job.
D. Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?
A. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us- east1 and us-west1.
B. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us- west1.
C. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us- east1 and us-west1.
D. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us- central1, us-east1, and us-west1.
正解：A
解説: (Topexam メンバーにのみ表示されます)

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