Google Professional Cloud Database Engineer Question 238
Single answerGoogle Cloud PlatformYour company runs a mission-critical application that requires a relational database with high availability and automatic failover. The database must also support zero-downtime maintenance and scale seamlessly based on workload. Which Google Cloud solution would you choose to meet these requirements?
- A
Cloud SQL with a multi-zone instance configuration
- B
Cloud Spanner with multi-region configuration
- C
BigQuery with regional dataset configuration
- D
Compute Engine with a self-managed MySQL database cluster
Show answer and explanation
Correct answer: B
Explanation
Cloud Spanner with a multi-region configuration is the best solution for this scenario because it is specifically designed for mission-critical applications requiring high availability, automatic failover, and zero-downtime maintenance. It also scales seamlessly to handle varying workloads, making it ideal for the given requirements.
- A. Incorrect.
Cloud SQL with a multi-zone instance configuration provides high availability within a single region, but it does not support multi-region replication or fully eliminate downtime during maintenance. It is not the best solution for mission-critical applications requiring geographical redundancy.
- B. Correct.
Cloud Spanner with multi-region configuration is designed for mission-critical applications. It provides automatic failover, zero-downtime maintenance, and seamless scaling. It is the ideal solution for the given requirements.
- C. Incorrect.
BigQuery is an analytics database and is not designed for transactional workloads or high availability in the context of a relational database. It does not meet the requirements of the scenario.
- D. Incorrect.
Compute Engine with a self-managed MySQL database cluster requires manual management of high availability, failover, and maintenance. This approach introduces significant operational overhead and does not guarantee zero-downtime maintenance.