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…

Question

Options

• AConfigure the automated backups to use a regional Cloud Storage bucket as a custom location.
• BUse the default configuration for the automated backups location.
• CDisable automated backups, and create an on-demand backup routine to a regional Cloud
• DDisable automated backups, and configure serverless exports to a regional Cloud Storage

• A
  81% (22)
• B
  4% (1)
• C
  11% (3)
• D
  4% (1)

Explanation

By default, Cloud SQL stores automated backups in a multi-regional location (e.g., 'US' or 'EU') rather than in the specific region where the instance runs. This default behavior (Option B) would violate regulations requiring backups to reside in the exact region of the database. Options C and D both require disabling automated backups and implementing manual export routines, which significantly increase operational overhead and cost. Option A is correct: Cloud SQL allows you to configure a custom backup location, letting you specify a specific regional Cloud Storage bucket. This satisfies the regulatory requirement while retaining the simplicity and low overhead of Cloud SQL's built-in automated backup system - no custom scripts, Compute Engine VMs, or additional orchestration needed.

No community discussion yet for this question.