Google Professional Cloud Database Engineer Question 139
Select 2Google Cloud PlatformYour organization uses a Cloud SQL instance for its critical transactional database. The database must meet the Recovery Point Objective (RPO) of 5 minutes and a Recovery Time Objective (RTO) of 10 minutes. You need to implement a suitable backup and recovery strategy. What should you do?
- A
Enable automated backups and set the backup retention period to 7 days.
- B
Enable point-in-time recovery (PITR) for the Cloud SQL instance.
- C
Schedule on-demand backups every 5 minutes using a custom script.
- D
Implement a high-availability (HA) configuration for the Cloud SQL instance.
- E
Configure export-based backups to Cloud Storage once per day.
Show answer and explanation
Correct answers: A, B
Explanation
To meet the RPO of 5 minutes and RTO of 10 minutes, you need to enable automated backups along with point-in-time recovery (PITR). Automated backups ensure regular snapshots of the database, while PITR allows you to restore to any specific time within the backup retention period. Other options, such as on-demand backups and export-based backups, are not practical for meeting such tight RPO and RTO requirements, and high availability focuses on uptime rather than backup and recovery.
- A. Correct.
Enabling automated backups ensures that the database is backed up regularly and can be restored when required, but it alone does not meet the 5-minute RPO requirement.
- B. Correct.
Point-in-time recovery (PITR) is critical for meeting the RPO of 5 minutes, as it allows you to restore the database to a precise point within a short time frame.
- C. Incorrect.
Scheduling on-demand backups every 5 minutes could technically achieve the RPO but is operationally inefficient and not a recommended or scalable solution.
- D. Incorrect.
High-availability configurations improve uptime but do not directly address backup and recovery needs such as RPO or RTO requirements.
- E. Incorrect.
Export-based backups to Cloud Storage are suitable for long-term archival purposes but do not meet the 5-minute RPO requirement as they occur only once a day.