最新なGoogle Professional-Cloud-Database-Engineer問題集（220題）、真実試験の問題を全部にカバー！

質問 1：
Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?
A. Build a Firestore bundle, and deploy bundles to Cloud CDN.
B. Deploy a US multi-region Firestore location.
C. Create a Firestore index on the news story date.
D. Enable serializable isolation in the Firebase app.
正解：A

質問 2：
You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than
5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?
A. Set your production instance's maintenance window to non-business hours.
B. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
C. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
D. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
正解：A

質問 3：
You are migrating your company's critical ecommerce platform from an on-premises PostgreSQL database (utilizing PostgreSQL stored procedures) to a highly available solution on Google Cloud. The platform requires an extremely low downtime (Recovery Time Objective (RTO) - 5 minutes) and minimal data loss (Recovery Point Objective - 30 seconds). The platform serves a global customer base with peak traffic distributed across multiple continents, though the primary transactional data resides in a single geographic region for regulatory compliance. You need to design a cloud database solution that meets the RTO/RPO requirements while optimizing for global read access and local transactional integrity. What should you do-
A. Implement a multi-regional Cloud SQL for PostgreSQL deployment with read replicas in different regions, and configure asynchronous replication for cross-region data consistency.
B. Deploy an AlloyDB cluster in the primary region with a high-availability instance configuration, and establish cross-region read replicas in another region for global read scaling.
C. Implement a single-instance Spanner deployment configured for multi-regional data replication.
D. Deploy a single-region AlloyDB cluster with a primary instance and a read replica in the same zone.
正解：B
解説: (Pass4Test メンバーにのみ表示されます)

質問 4：
You are migrating an on-premises online transactional process (OLTP) PostgreSQL database to Google Cloud. You want to reduce the administrative overhead on database maintenance activities, such as vacuum and memory tuning. You are also planning to introduce analytic use cases in this database. You need the migration to have minimal schema and application changes.
What should you do-
A. Deploy a self-managed PostgreSQL database on Compute Engine.
B. Use Cloud SQL for PostgreSQL.
C. Use Spanner with PGAdapter.
D. Use AlloyDB for PostgreSQL.
正解：D
解説: (Pass4Test メンバーにのみ表示されます)

質問 5：
Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?
A. Connect to Cloud SQL using a connection that has SSL encryption.
B. Use Cloud SQL Auth proxy.
C. Use customer-managed encryption keys with Cloud SQL.
D. Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.
正解：C