Google Professional Cloud Database Engineer Question 23
Single answerGoogle Cloud PlatformYou are designing a database solution for a financial services company that requires high availability and disaster recovery. The company wants to minimize downtime in case of a regional failure and ensure automatic failover with no manual intervention. Which solution would best meet these requirements?
- A
Use Cloud SQL with a cross-region read replica and configure the replica for failover.
- B
Use Cloud Spanner with multi-region configuration to ensure automatic failover and redundancy.
- C
Use a single Cloud SQL instance with daily backups to Cloud Storage for disaster recovery.
- D
Use Firestore in single-region mode and export data to BigQuery for disaster recovery.
Show answer and explanation
Correct answer: B
Explanation
The company requires a solution that ensures high availability, disaster recovery, and automatic failover. Cloud Spanner with a multi-region configuration is the only option that fulfills all these requirements. It is specifically designed for mission-critical workloads with zero downtime and built-in redundancy across regions. Other options either lack automatic failover or do not provide sufficient disaster recovery mechanisms.
- A. Incorrect.
Cloud SQL with a cross-region read replica allows for read replication but does not provide automatic failover. Promoting a read replica to primary is a manual process, which violates the requirement for automatic failover.
- B. Correct.
Cloud Spanner with multi-region configuration is designed for high availability and disaster recovery. It provides strong consistency, automatic failover, and redundancy across multiple regions, meeting all the requirements in the scenario.
- C. Incorrect.
A single Cloud SQL instance with daily backups provides a basic disaster recovery solution but does not offer high availability or automatic failover. Downtime would be significant in the event of a regional failure.
- D. Incorrect.
Firestore in single-region mode does not provide high availability or disaster recovery in case of a regional failure. Exporting data to BigQuery is suitable for analytics but not for operational disaster recovery or failover.