Google Cloud Professional Cloud Database Engineer — Question 148

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?

Answer options

• A. Schedule automated backups for Cloud SQL with a retention period of 365 days.
• B. Schedule daily and monthly on-demand backups.
• C. Schedule automated backups, and create on-demand monthly backups to custom backup locations.
• D. Create an Organization Policy Service resource location constraint. Schedule automated backups with the retention period of 30 days.

Correct answer: C

Explanation

The correct answer is C because it ensures that both automated and on-demand monthly backups are created, allowing for compliance with data residency regulations while providing flexibility in backup locations. Option A does not address the need for monthly on-demand backups, B lacks the automation aspect and retention requirements, and D does not meet the retention period needed for the backups.