Google Professional-Cloud-Database-Engineer 問題集

質問 1：
You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)
A. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
B. Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
C. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
D. Use a change data capture (CDC) migration strategy.
E. Move the physical database servers from on-premises to Google Cloud.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?
A. Use Bigtable with clusters in multiple regions to deploy the database
B. Use Cloud Spanner to deploy the database.
C. Use Cloud SQL with a regional read replica to deploy the database.
D. Use BigQuery to deploy the database
正解：B
解説: (Topexam メンバーにのみ表示されます)

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

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

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

質問 6：
You are a DBA on a Cloud Spanner instance with multiple databases. You need to assign these privileges to all members of the application development team on a specific database:
Can read tables, views, and DDL
Can write rows to the tables
Can add columns and indexes
Cannot drop the database
What should you do?
A. Assign the Cloud Spanner Admin role.
B. Assign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.
C. Assign the Cloud Spanner Database Admin role.
D. Assign the Cloud Spanner Database User role.
正解：D
解説: (Topexam メンバーにのみ表示されます)

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

質問 9：
You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?
A. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
B. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
C. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
D. Configure the primary, standby, and read replica instances in zone A, all in the same region.
正解：B
解説: (Topexam メンバーにのみ表示されます)