Google Professional Cloud Database Engineer Question 155
Single answerGoogle Cloud PlatformYour organization hosts a mission-critical e-commerce application on Google Cloud. The application uses Cloud SQL for its database. The business requires a recovery time objective (RTO) of 15 minutes and a recovery point objective (RPO) of 5 minutes to minimize downtime and data loss. Which configuration should you implement to meet these requirements?
- A
Enable automated backups and set the backup window to 15 minutes.
- B
Use point-in-time recovery (PITR) and configure a high-availability (HA) instance.
- C
Set up a read replica in a different region and rely on replication for recovery.
- D
Perform manual backups every 5 minutes and store them in a Cloud Storage bucket.
Show answer and explanation
Correct answer: B
Explanation
To meet the strict RTO of 15 minutes and RPO of 5 minutes, point-in-time recovery (PITR) is the most appropriate choice as it allows for restoring the database to any point in the last 7 days. Combining this with a high-availability (HA) configuration ensures quick failover in case of an instance failure, minimizing downtime and fulfilling the RTO requirement. Other options either lack the precision required for the RPO or are impractical to implement.
- A. Incorrect.
Automated backups are useful for disaster recovery but are not frequent enough to meet an RPO of 5 minutes. The backup window setting only determines when automated backups occur but does not guarantee frequent recovery points.
- B. Correct.
Point-in-time recovery (PITR) allows for fine-grained recovery to a specific point within the last 7 days, meeting the RPO of 5 minutes. A high-availability instance ensures failover within minutes, satisfying the RTO of 15 minutes.
- C. Incorrect.
While read replicas can provide some level of redundancy, they are not designed for recovery purposes and cannot guarantee recovery to a specific point in time, making them unsuitable for a 5-minute RPO.
- D. Incorrect.
Manual backups every 5 minutes are operationally impractical and error-prone. Additionally, manual processes cannot ensure that the RTO of 15 minutes is consistently met.