Google Professional Cloud Database Engineer Question 146
Single answerGoogle Cloud PlatformYou are a database engineer for an e-commerce platform running on Cloud SQL for PostgreSQL. The platform has an SLA of 99.95% uptime and an SLO that requires no more than 5 minutes of data loss in case of failure. What backup and recovery configuration should you implement to meet both the SLA and SLO requirements?
- A
Enable automatic daily backups and configure point-in-time recovery (PITR) with a 7-day retention period.
- B
Enable automatic daily backups only and set a 30-day retention period.
- C
Disable automatic backups and rely solely on manual backups created every 12 hours.
- D
Enable automatic daily backups and configure on-demand backups every 12 hours.
Show answer and explanation
Correct answer: A
Explanation
To meet both the SLA of 99.95% uptime and the SLO of minimizing data loss to under 5 minutes, it is essential to enable automatic daily backups and configure point-in-time recovery (PITR). Automatic backups ensure data availability, while PITR allows recovery to a specific point, reducing potential data loss.
- A. Correct.
This option meets the SLA by ensuring regular automatic backups and meets the SLO by allowing recovery to any point within the last 7 days, minimizing potential data loss to under 5 minutes with PITR.
- B. Incorrect.
Although this option ensures automatic daily backups, it doesn't meet the SLO of minimizing data loss to 5 minutes as it lacks point-in-time recovery (PITR).
- C. Incorrect.
This option relies on manual processes and doesn't meet the SLA of 99.95% uptime or the SLO of minimizing data loss to 5 minutes, as manual backups are error-prone and infrequent.
- D. Incorrect.
While this option provides frequent backups, it doesn't meet the SLO of minimizing data loss to under 5 minutes because it lacks point-in-time recovery (PITR).