Google Exam Professional-Cloud-Database-Engineer Topic 2 Question 46 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 46
Topic #: 2

[All Professional Cloud Database Engineer Questions]

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?

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 Storage bucket.

DDisable automated backups, and configure serverless exports to a regional Cloud Storage bucket.

Show Suggested Answer

Suggested Answer: 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.

by Wilson at Sep 18, 2024, 12:00 PM

Limited Time Offer

25%

Off

Get Premium Professional-Cloud-Database-Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Josephine

1 days ago

Hmm, Option D looks interesting, but I'm not sure I'd want to deal with the complexity of serverless exports. Automated backups seem like the way to go here.

upvoted 0 times

...

Domonique

2 days ago

Option C is a bit overkill, don't you think? Disabling automated backups and setting up a whole new routine? Sounds like a lot of work for no real benefit.

upvoted 0 times

...

Hana

11 days ago

I'd go with Option B. Why bother with all that extra configuration when the default option is probably just fine? Keep it simple, ya know?

upvoted 0 times

...

Billy

21 days ago

Option A seems like the best choice to meet the regulatory requirements while minimizing costs and effort. No need to complicate things with custom backups.

upvoted 0 times