google · Professional-Cloud-Database-Engineer · Q427 · multiple_choice · topic_1

You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the…

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?

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

Selected Answer: A Let's eliminate: B - defaul is multi-regional even if your instance is regional C and D - you don't need to disable automated backups, this will increase administrative efforts All you need to do is to edit your backups and choose to store them in the region that you want instead of multi-regional. A is the answer.

Reference: examtopics_top_comment

Practice with progress tracking

Start tracked practice Pricing