Google Professional Cloud Database Engineer Question 144
Single answerGoogle Cloud PlatformYour company operates a mission-critical application hosted on Google Cloud Spanner. The Service Level Objective (SLO) for this application requires a Recovery Time Objective (RTO) of 15 minutes and a Recovery Point Objective (RPO) of 1 hour. Which backup and recovery option should you configure to meet these requirements?
- A
Configure automatic scheduled backups to run every 24 hours and use point-in-time recovery (PITR) to restore data.
- B
Enable point-in-time recovery (PITR) and configure continuous backup with a retention period of 7 days.
- C
Schedule manual backups to run every 6 hours and enable point-in-time recovery (PITR) for additional protection.
- D
Configure automatic scheduled backups to run every 12 hours and perform manual backups during critical periods.
Show answer and explanation
Correct answer: B
Explanation
To meet the given SLAs and SLOs, both RTO and RPO must be satisfied. Continuous backup with point-in-time recovery (PITR) ensures that data can be restored to any point within the retention window, meeting the strict RPO and RTO requirements. Scheduled or manual backups alone cannot guarantee the required recovery objectives, especially for mission-critical applications.
- A. Incorrect.
This option doesn't meet the RPO requirement of 1 hour, as backups running every 24 hours could result in data loss beyond the acceptable threshold. While PITR can help with restoring data to a specific point in time, the backup frequency needs to align with the RPO.
- B. Correct.
This option meets both the RTO and RPO requirements. Point-in-time recovery (PITR) allows you to restore data within the specified retention window, and continuous backup ensures data is protected in near real-time, satisfying the 1-hour RPO and 15-minute RTO.
- C. Incorrect.
Manual backups introduce operational overhead and may not consistently meet the 1-hour RPO requirement. While PITR adds extra protection, relying on manual backups is not a reliable approach for mission-critical applications.
- D. Incorrect.
Automatic scheduled backups every 12 hours do not meet the 1-hour RPO requirement, and relying on manual backups during critical periods is operationally risky and error-prone.