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

2 months 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 months 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

Mabel

1 months ago

Stefania: Definitely, we want to make sure we're compliant without creating unnecessary work for ourselves.

upvoted 0 times

...

Stefania

1 months ago

I agree, it's a good balance between meeting the regulations and minimizing costs.

upvoted 0 times

...

Loreta

1 months ago

I think option A is the best choice. It allows us to keep the backups in the same region without too much extra effort.

upvoted 0 times

...

Hana

2 months 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

Hannah

1 months ago

User1: True, but sometimes simplicity is key in managing databases.

upvoted 0 times

...

Wilda

1 months ago

User3: I prefer Option A. It's better to have control over where the backups are stored.

upvoted 0 times

...

Mozell

1 months ago

User2: Yeah, I agree. Why make it more complicated than it needs to be?

upvoted 0 times

...

Pete

2 months ago

Disabling automated backups and creating an on-demand backup routine to a regional Cloud Storage bucket could be a good compromise.

upvoted 0 times

...

Hoa

2 months ago

I think configuring automated backups to use a regional Cloud Storage bucket is a better choice for compliance with regulations.

upvoted 0 times

...

Kenneth

2 months ago

I think Option B is the way to go. Default is usually good enough.

upvoted 0 times

...

Adelle

2 months ago

I agree, keeping it simple with the default option sounds like the way to go.

upvoted 0 times

...

Billy

3 months 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