Google Professional-Cloud-Database-Engineer 問題集

質問 1：
You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?
A. Enable high availability (HA) for the database to make it regional.
B. Create a read replica in another region, and promote the read replica if a failure occurs.
C. Take nightly snapshots of the primary database instance, and restore them in a secondary zone.
D. Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.
正解：A

質問 2：
Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?
A. Identify and optimize slow running queries, or set parallel replication flags.
B. Edit the primary instance to add additional memory.
C. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
D. Stop all running queries, and re-create the replicas.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You are running a large, highly transactional application on Oracle Real Application Cluster (RAC) that is multi-tenant and uses shared storage. You need a solution that ensures high-performance throughput and a low-latency connection between applications and databases. The solution must also support existing Oracle features and provide ease of migration to Google Cloud. What should you do?
A. Migrate to Compute Engine.
B. Migrate to Google Kubernetes Engine (GKE)
C. Migrate to Google Cloud VMware Engine
D. Migrate to Bare Metal Solution for Oracle.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You work for a large retail and ecommerce company that is starting to extend their business globally. Your company plans to migrate to Google Cloud. You want to use platforms that will scale easily, handle transactions with the least amount of latency, and provide a reliable customer experience. You need a storage layer for sales transactions and current inventory levels. You want to retain the same relational schema that your existing platform uses. What should you do?
A. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
B. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
C. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
D. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
正解：C

質問 5：
Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?
A. Isolate the data analysts and operations user groups to use different Bigtable instances.
B. Add more nodes to the Bigtable cluster.
C. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
D. Use Key Visualizer for Bigtable.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?
A. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
B. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
C. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
D. Use Cloud Composer to execute a select * from table(s) query and export results.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?
A. Use Firestore.
B. Use Bigtable.
C. Use Cloud SQL for MySQL
D. Use Cloud Spanner.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You are writing an application that will run on Cloud Run and require a database running in the Cloud SQL managed service. You want to secure this instance so that it only receives connections from applications running in your VPC environment in Google Cloud. What should you do?
A. 1. Create your instance with a specified internal (private) IP address.
2. Choose the VPC with private service connection configured.
3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
4. Connect to the instance using a connection pool to best manage connections to the instance.
B. 1. Create your instance with a specified external (public) IP address.
2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
3. Connect to the instance using a connection pool to best manage connections to the instance.
C. 1. Create your instance with a specified internal (private) IP address.
2. Choose the VPC with private service connection configured.
3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
4. Use Cloud SQL Auth proxy to connect to the instance.
D. 1. Create your instance with a specified external (public) IP address.
2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
3. Use Cloud SQL Auth proxy to connect to the instance.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?
A. Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.
B. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
C. Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.
D. Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
正解：B
解説: (Topexam メンバーにのみ表示されます)