Google Professional-Cloud-Database-Engineer 問題集

質問 1：
You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?
A. Use Dataflow to run the export in text format.
B. Use Dataflow to run the export in Avro format.
C. Use Cloud Functions to run the export in text format.
D. Use Cloud Functions to run the export in Avro format.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?
A. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
B. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
C. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.
D. Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?
A. Migrate the Oracle databases to Compute Engine.
B. Migrate the Oracle databases to Cloud Spanner.
C. Migrate the Oracle databases to Cloud SQL.
D. Migrate the Oracle databases to Bare Metal Solution for Oracle.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?
A. Bring DB-1 back online.
B. Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
C. Delete DB-2 so that DB-1 automatically reverts to the primary instance.
D. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?
A. Use Memorystore for data storage.
B. Use Cloud SQL for data storage.
C. Use Cloud Spanner for data storage.
D. Use Bigtable for data storage.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?
A. Use Firestore.
B. Use Bigtable.
C. Use Cloud SQL.
D. Use Cloud Spanner.
正解：D

質問 7：
You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?
A. Use high availability (HA) Cloud SQL with multiple zones.
B. Use zonal Cloud SQL without high availability (HA).
C. Use Cloud SQL with cross-region replicas.
D. Use Cloud Spanner in a regional configuration.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of dat a. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?
A. Use a Biglable cluster with autoscaling.
B. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
C. Use sharded Cloud SQL instances with one or more stores per database instance.
D. Use Cloud Spanner with a custom autoscaling solution.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 9：
You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?
A. Reduce the number of automated backups that are retained to two (2).
B. Select a different region to store your backups.
C. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
D. Set the automated backups to occur every other day to lower the frequency of backups.
正解：A
解説: (Topexam メンバーにのみ表示されます)