Google Professional Cloud Database Engineer Question 156
Single answerGoogle Cloud PlatformYour company runs a mission-critical database on Google Cloud, and you are tasked with designing a disaster recovery strategy. The business requires a Recovery Time Objective (RTO) of 5 minutes and a Recovery Point Objective (RPO) of 1 minute. Which solution should you implement to meet these requirements?
- A
Set up a daily automated backup of the database and store it in Cloud Storage.
- B
Use Cloud Spanner with multi-region configuration to replicate data across regions in near real-time.
- C
Use Cloud SQL with a read replica in a separate region and configure automated backups.
- D
Implement a manual failover process for a Compute Engine-hosted database with snapshots taken every 10 minutes.
Show answer and explanation
Correct answer: B
Explanation
To meet an RTO of 5 minutes and an RPO of 1 minute, you need a solution that provides near real-time data replication and a fast failover mechanism. Cloud Spanner with a multi-region configuration is specifically designed for such requirements, ensuring minimal data loss and fast recovery in case of a disaster.
- A. Incorrect.
Daily automated backups do not meet the RPO requirement of 1 minute, as data could be lost between backup intervals. RTO is also not achievable in 5 minutes with this approach, as restoring from a daily backup would take much longer.
- B. Correct.
Cloud Spanner with a multi-region configuration is designed for high availability and disaster recovery. It replicates data across regions in near real-time, ensuring an RPO of less than 1 minute. It also provides a seamless failover process, meeting the RTO of 5 minutes.
- C. Incorrect.
While Cloud SQL read replicas can improve availability and support disaster recovery, the automated backups and read replica setup do not guarantee an RPO of 1 minute, as there is still a delay in syncing data and restoring backups takes time.
- D. Incorrect.
A manual failover process combined with snapshots taken every 10 minutes does not meet the RPO requirement of 1 minute, as data could be lost within the 10-minute snapshot interval. Additionally, a manual failover process may take longer than 5 minutes, failing the RTO requirement.