Google Professional Cloud Database Engineer Question 148
Single answerGoogle Cloud PlatformYou are managing a Cloud SQL instance hosting a critical production database. The database has an uptime SLA of 99.95%, and the business requires a recovery point objective (RPO) of 15 minutes and a recovery time objective (RTO) of 30 minutes. To meet these requirements, what is the best backup and recovery configuration for the database?
- A
Enable automatic daily backups and set the backup retention period to 30 days.
- B
Enable point-in-time recovery (PITR) and use binary log replication.
- C
Enable automated backups with a custom schedule to run every 6 hours.
- D
Enable automated backups and point-in-time recovery (PITR).
Show answer and explanation
Correct answer: D
Explanation
To meet both a 15-minute RPO and a 30-minute RTO, you need a solution that minimizes data loss and ensures quick recovery. Automated backups provide a baseline for recovery, while point-in-time recovery (PITR) enables precise restoration to any point within the backup retention period, ensuring compliance with the RPO and RTO. Other options either fail to meet the RPO requirement or lack sufficient recovery capability.
- A. Incorrect.
Daily backups alone do not meet the RPO of 15 minutes because backups occur only once per day, leaving the potential for significant data loss beyond the 15-minute requirement.
- B. Incorrect.
Binary log replication alone does not enable point-in-time recovery (PITR). Additionally, while PITR is necessary for this scenario, it must be enabled explicitly alongside automated backups to meet the RPO and RTO requirements.
- C. Incorrect.
Running automated backups every 6 hours does not meet the RPO of 15 minutes. Backups at this interval increase the potential data loss window significantly beyond the requirements.
- D. Correct.
Enabling automated backups ensures regular backups of the database, and enabling point-in-time recovery (PITR) allows granular recovery to within seconds of the failure, fully meeting both the RPO of 15 minutes and the RTO of 30 minutes.