Google Professional Cloud Database Engineer Question 145
Single answerGoogle Cloud PlatformYou are managing a Cloud Spanner database for a financial application with an SLA of 99.99% availability and an SLO requiring a maximum recovery time of 15 minutes in the event of data loss. Which automatic backup and recovery configuration should you implement to meet these requirements?
- A
Enable daily automatic backups with a 7-day retention period and use point-in-time recovery (PITR).
- B
Enable weekly automatic backups with a 30-day retention period and use manual recovery processes.
- C
Enable daily automatic backups with a 30-day retention period and disable point-in-time recovery (PITR).
- D
Enable hourly automatic backups with a 7-day retention period and use point-in-time recovery (PITR).
Show answer and explanation
Correct answer: A
Explanation
To meet the SLA of 99.99% availability and the SLO requiring a maximum 15-minute recovery time, daily automatic backups combined with point-in-time recovery (PITR) offer the best balance of granularity, recovery speed, and resource efficiency. PITR ensures that recovery can be performed to a specific point in time within the required window, while daily backups provide a reliable base for data restoration.
- A. Correct.
This option is correct as daily backups combined with point-in-time recovery (PITR) provide the ability to recover within the required 15-minute recovery time objective (RTO), meeting both the SLA and SLO requirements.
- B. Incorrect.
This option is incorrect because weekly backups do not provide sufficient granularity for quick recovery, and manual recovery processes typically exceed the 15-minute recovery time objective (RTO).
- C. Incorrect.
This option is incorrect because disabling point-in-time recovery (PITR) limits the ability to recover to a specific point, which is crucial for meeting the 15-minute recovery time objective (RTO).
- D. Incorrect.
This option is incorrect because while hourly backups provide granularity, they are more resource and cost-intensive than necessary for the given SLA and SLO, and the 7-day retention period may not meet compliance requirements depending on the financial application.