Google Professional Cloud Database Engineer Question 235
Single answerGoogle Cloud PlatformYour company runs a mission-critical e-commerce application on Google Cloud, and it requires a highly available relational database with minimal downtime during maintenance and failover. Which solution would best meet these requirements?
- A
Deploy a Cloud SQL instance with a read replica in another region.
- B
Use a Cloud SQL instance with high availability configuration enabled.
- C
Deploy a standalone Compute Engine VM running MySQL with persistent disks in a regional configuration.
- D
Use Firestore in Datastore mode for its global availability and low-latency reads.
Show answer and explanation
Correct answer: B
Explanation
The high availability configuration in Cloud SQL is designed to provide redundancy and automatic failover within a region. It ensures minimal downtime during maintenance and failover events, making it an ideal solution for mission-critical applications requiring high availability. Other options either lack automatic failover, are not relational databases, or are not designed for high availability.
- A. Incorrect.
While a read replica can improve read performance and provide some redundancy, it does not provide automatic failover, which is critical for high availability.
- B. Correct.
Cloud SQL’s high availability configuration creates a primary instance and a standby instance in different zones within the same region. It provides automatic failover and minimizes downtime during maintenance.
- C. Incorrect.
A standalone Compute Engine VM running MySQL does not provide the automated failover, redundancy, or managed maintenance that Cloud SQL does, making it less suitable for high availability needs.
- D. Incorrect.
Firestore in Datastore mode is not a relational database and is not suitable for use cases requiring relational data models and SQL queries.