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.
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.
in default two option - Click Multi-region (default) or Region.
In the Google Cloud console, go to the Cloud SQL Instances page.
Go to Cloud SQL Instances
To open the Overview page of an instance, click the instance name.
From the SQL navigation menu, select Backups.
Next to Settings, click Edit.
In the Automated Backups section, expand Advanced Options.
Click Multi-region (default) or Region.
Select the location from the Location drop-down menu.
Click Save.
https://cloud.google.com/sql/docs/mysql/backup-recovery/backing-up#locationbackups
Cloud SQL lets you select a custom location for your backup data. This is useful if your organization needs to comply with data residency regulations that require you to keep your backups within a specific geographic boundary. If your organization has this type of requirement, it probably uses a Resource Location Restriction organizational policy.
A
https://cloud.google.com/sql/docs/mysql/backup-recovery/backing-up#locationbackups
You can use a custom location for on-demand and automatic backups. For a complete list of valid location values, see the Instance locations.
A
"""
Where backups are stored
Backups locations include:
Default locations that Cloud SQL selects, based on the location of the original instance.
Custom locations that you choose when you do not want to use the default location.
"""
https://cloud.google.com/sql/docs/mysql/backup-recovery/backups
"""
Set a custom location for backups
Only use a custom backup location if required by regulation. If not required, use the default multi-region backup location.
You can use a custom location for on-demand and automatic backups.
"""
https://cloud.google.com/sql/docs/mysql/backup-recovery/backing-up#locationbackups
C.
You cannot configure a custom location for automatic backups. A is wrong. The default option for automatic backups is multi-region. B is wrong. The question specifically mentions backups not exports, so eliminate D. That leaves C which involves manual effort, but it does keep the data in the correct region.
A - https://cloud.google.com/sql/docs/mysql/backup-recovery/backups#default-backup-location
"If you do not specify a storage location, your backups are stored in the multiregion that is geographically closest to the location of your Cloud SQL instance."
C: Disable automated backups, and create an on-demand *** backup routine to a regional Cloud Storage bucket.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
chelbsik
Highly Voted 1 year, 6 months agosky09
Most Recent 6 days agosky09
6 days agoPime13
1 month, 3 weeks agoDPonly
9 months agopico
10 months, 1 week agoabsero1609
1 year, 1 month agodynamic_dba
1 year, 3 months agoH_S
1 year, 3 months agoH_S
1 year, 3 months agomarpayer
1 year, 5 months agopk349
1 year, 6 months ago