
Ultimate access to all questions.
How can you ensure Cloud SQL database backups remain in the same region as the database while minimizing operational costs and administrative overhead?
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.
Explanation:
To comply with the regulation requiring database backups to reside in the same region as the database, and to minimize operational costs and administrative effort, the best approach is to configure the automated backups to use a regional Cloud Storage bucket as a custom location (Option A). This ensures backups are stored in the same region as the database, meeting regulatory requirements, and leverages automated backups to reduce administrative effort. Option B does not guarantee that backups will reside in the same region as the database, as the default configuration might not be region-specific. Options C and D involve disabling automated backups, which increases administrative effort and does not align with the goal of minimizing operational costs and administrative effort.