Google Professional-Cloud-Database-Engineer 問題集

質問 1：
Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)
A. Create a PostgreSQL database on-premises as the HA option.
B. Schedule automated backups.
C. Enable point-in-time recovery.
D. Configure single zone availability for automated backups.
E. Set up manual backups.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped. What should you do?
A. Set Terraform deletion_protection to true.
B. Use point-in-time-recovery (PITR) to recover the database.
C. Create a read replica.
D. Rerun terraform apply.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Your company is evaluating Google Cloud database options for a mission-critical global payments gateway application. The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases. You need to select an automatically shardable, fully managed database with 99.999% availability and strong transactional consistency. What should you do?
A. Select Bigtable.
B. Select Cloud SQL.
C. Select Cloud Spanner.
D. Select Bare Metal Solution for Oracle.
正解：C
解説: (Topexam メンバーにのみ表示されます)

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

質問 5：
You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?
A. Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.
B. Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.
C. Set up different organizations for each database type, and apply policy constraints at the organization level.
D. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.
正解：D

質問 6：
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

質問 7：
You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?
A. Automate instance creation by writing a Dataflow job.
B. Create the instances using the Google Cloud Console UI.
C. Create clones from a template Cloud SQL instance.
D. Automate instance creation by setting up Terraform scripts.
正解：D

質問 8：
You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries.
What should you do?
A. White a Logs Explorer query to identify database queries with high execution times.
B. Use the Query Insights dashboard to identify high execution times.
C. View Cloud SQL operations to view historical query information.
D. Review application logs to identify database calls.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 9：
You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource- intensive queries. What should you do?
A. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
B. Use log messages produced by Cloud SQL.
C. Use Cloud SQL instance monitoring in the Google Cloud Console.
D. Use Query Insights for Cloud SQL.
正解：D
解説: (Topexam メンバーにのみ表示されます)