PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #176
Your organization's databases are running in Cloud SQL. Due to data residency regulations, your organization mandates that backups are stored in a specific region. You are also required to make sure…
The correct answer is C. Schedule automated backups, and create on-demand monthly backups to custom backup. Use Cloud SQL’s built-in automated backups for your daily recovery window, and supplement them with on-demand (manual) full backups each month. Store those monthly backups in a customer-managed Cloud Storage bucket that you place in your required region - this satisfies the…
Question
Your organization’s databases are running in Cloud SQL. Due to data residency regulations, your organization mandates that backups are stored in a specific region. You are also required to make sure that the databases have monthly full backups, which are retained until your Cloud SQL instance is deleted, along with daily backups. What should you do-
Options
- ASchedule automated backups for Cloud SQL with a retention period of 365-days.
- BSchedule daily and monthly on-demand backups.
- CSchedule automated backups, and create on-demand monthly backups to custom backup
- DCreate an Organization Policy Service resource location constraint. Schedule automated backups
How the community answered
(40 responses)- A10% (4)
- B3% (1)
- C83% (33)
- D5% (2)
Explanation
Use Cloud SQL’s built-in automated backups for your daily recovery window, and supplement them with on-demand (manual) full backups each month. Store those monthly backups in a customer-managed Cloud Storage bucket that you place in your required region - this satisfies the residency rule and keeps them until you explicitly delete the instance (on-demand backups aren’t auto-purged). Automated backups handle the daily retention, and your manual monthly snapshots live as long as you need.
Topics
Community Discussion
No community discussion yet for this question.