Google Professional Cloud Database Engineer Question 25
Select 2Google Cloud PlatformYour organization is running a mission-critical e-commerce application on Google Cloud. The database must have minimal downtime in case of a failure, support multi-region disaster recovery, and ensure that data integrity is maintained. Which combination of high availability and disaster recovery strategies should you implement to meet these requirements?
- A
Use Cloud Spanner with multi-region configuration and strong consistency settings.
- B
Use a single-region Cloud SQL instance with automated backups enabled.
- C
Deploy Cloud SQL with high availability configuration and cross-region replicas.
- D
Use Firestore in Datastore mode with multi-region configuration.
- E
Deploy a self-managed MySQL instance on Compute Engine with persistent disk snapshots.
Show answer and explanation
Correct answers: A, C
Explanation
To meet the requirements of minimal downtime, multi-region disaster recovery, and data integrity, Cloud Spanner's multi-region configuration with strong consistency and Cloud SQL with HA configuration and cross-region replicas are the most appropriate solutions. Both options provide native support for high availability and disaster recovery while minimizing operational complexity for mission-critical workloads.
- A. Correct.
Cloud Spanner with a multi-region configuration provides built-in high availability and disaster recovery. Strong consistency ensures data integrity, making it a suitable option for mission-critical workloads.
- B. Incorrect.
A single-region Cloud SQL instance with automated backups only provides point-in-time recovery within the same region. It does not meet the high availability or multi-region disaster recovery requirements.
- C. Correct.
Cloud SQL with high availability (HA) configuration provides synchronous replication within a region, and cross-region replicas ensure disaster recovery. This combination satisfies both high availability and disaster recovery needs.
- D. Incorrect.
Firestore in Datastore mode with multi-region configuration provides high availability but does not meet the relational database requirements for this scenario.
- E. Incorrect.
A self-managed MySQL instance on Compute Engine with persistent disk snapshots requires significant operational overhead. Additionally, it does not natively support high availability or multi-region disaster recovery.