Google Professional Cloud Database Engineer Question 147
Single answerGoogle Cloud PlatformA company is running a mission-critical application on Google Cloud using Cloud SQL for PostgreSQL. The company has committed to an SLA that ensures 99.9% availability and requires a recovery point objective (RPO) of 5 minutes and a recovery time objective (RTO) of 15 minutes. Which backup and recovery strategy should you recommend to meet these requirements?
- A
Enable automatic daily backups in Cloud SQL and perform on-demand backups before any major changes.
- B
Enable automated continuous backups and point-in-time recovery in Cloud SQL.
- C
Manually export the database to Cloud Storage every hour and import it during a recovery scenario.
- D
Schedule a cron job to take a manual backup every 10 minutes using the gcloud CLI.
Show answer and explanation
Correct answer: B
Explanation
To meet both the SLA commitments and the stated RPO and RTO requirements, the recommended approach is to enable automated continuous backups with point-in-time recovery in Cloud SQL. This strategy ensures that the database can be restored to any point within the retention period, minimizing data loss and downtime.
- A. Incorrect.
Automatic daily backups only allow recovery to the state of the database at the time of the backup, which does not meet the RPO of 5 minutes. On-demand backups can be helpful but are not sufficient for continuous protection.
- B. Correct.
Automated continuous backups with point-in-time recovery allow the database to be restored to any point within the backup retention period, meeting both the RPO of 5 minutes and the RTO of 15 minutes.
- C. Incorrect.
Manually exporting the database every hour does not meet the RPO of 5 minutes as the backups are too infrequent. Additionally, manual processes increase the risk of human error and delay during recovery.
- D. Incorrect.
Manually scheduling backups every 10 minutes may help meet the RPO, but it introduces operational overhead and is prone to human error. Additionally, this approach does not provide an automated recovery process to meet the RTO requirement.