Google Cloud Professional Cloud Database Engineer — Question 64

You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?

Answer options

• A. Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
• B. Use the default configuration for the automated backups location.
• C. Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.
• D. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.

Correct answer: A

Explanation

The correct choice is A because configuring automated backups to use a regional Cloud Storage bucket ensures compliance with the regulations while maintaining low operational costs. Options B and C do not meet the requirement of keeping backups in the same region as the database, and option D involves unnecessary complexity by disabling automated backups.