Google Professional Cloud Database Engineer Exam - Topic 6 Question 40 Discussion

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

Question #: 40
Topic #: 6

[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 Zana at Aug 27, 2024, 09:35 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

Audra

3 months ago

Wait, can you really disable automated backups? That sounds sketchy!

upvoted 0 times

...

Deeanna

3 months ago

D seems like overkill for just backups, right?

upvoted 0 times

...

Elbert

4 months ago

C sounds risky, manual backups can be a hassle!

upvoted 0 times

...

Rasheeda

4 months ago

I think B is fine too, but it might not be as flexible.

upvoted 0 times

...

Anjelica

4 months ago

A is the best choice for compliance and cost-efficiency.

upvoted 0 times

...

Odelia

4 months ago

I feel like option C could be risky since it involves disabling automated backups, which could lead to data loss if not managed properly.

upvoted 0 times

...

Elmer

5 months ago

I practiced a similar question where disabling automated backups was not recommended, so I’m leaning towards option B, but I’m not completely confident.

upvoted 0 times

...

Margarett

5 months ago

I think option A sounds right since it allows for a custom location, but I’m a bit uncertain about the costs involved with that setup.

upvoted 0 times

...

Rutha

5 months ago

I remember we discussed that automated backups are usually the best option for minimizing effort, but I'm not sure if the default configuration meets the regional requirement.

upvoted 0 times

...

Elise

5 months ago

I'm leaning towards option D - disabling the automated backups and using serverless exports to a regional Cloud Storage bucket. That way I can have more control over the backup process and potentially save some costs compared to the automated option.

upvoted 0 times

...

Carli

5 months ago

Okay, let me think this through. Since the regulations require backups to be in the same region, I think option A of using a regional Cloud Storage bucket as the backup location is the way to go. That should minimize the effort compared to disabling automated backups and setting up a manual routine.

upvoted 0 times

...

Oretha

5 months ago

Hmm, I'm a bit unsure about this one. The question mentions regulations, so I need to be careful to comply with those. I'm not sure if the default backup configuration would meet the regional requirement or if I need to do something more custom.

upvoted 0 times

...

Rosalind

5 months ago

This seems like a straightforward question about managing Cloud SQL database backups. I think the key is to find the option that minimizes operational costs and administrative effort while still meeting the regulatory requirement for backups to reside in the same region as the database.

upvoted 0 times

...

Elza

5 months ago

I'm pretty confident that the Minimum Usable Subset in DSDM refers to the "Must Have" requirements, so I'm going to select option C.

upvoted 0 times

...

Doug

5 months ago

I think this question is testing our knowledge of Prisma Public Cloud's licensing model. I'll need to carefully review the options and think about which one best describes how Prisma Public Cloud is licensed.

upvoted 0 times

...

Cheryl

1 year ago

Wait, we're supposed to _minimize_ costs? I thought this was the cloud, where the sky's the limit!

upvoted 0 times

Julio

1 year ago

D) Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.

upvoted 0 times

...

Josephine

1 year ago

Wait, we're supposed to _minimize_ costs? I thought this was the cloud, where the sky's the limit!

upvoted 0 times

...

Diane

1 year ago

C) Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.

upvoted 0 times

...

Geraldo

1 year ago

A) Configure the automated backups to use a regional Cloud Storage bucket as a custom location.

upvoted 0 times

...

Dudley

1 year ago

Hey, at least it's not a NoSQL database, am I right? Those things are a whole other can of worms!

upvoted 0 times

...

Mitsue

1 year ago

C is the way to go, my dude! On-demand backups are where it's at. Plus, it'll keep the regulatory folks happy.

upvoted 0 times

...

Marlon

1 year ago

D sounds interesting, but I'm not sure about the whole 'serverless' thing. Might be a bit over my head.

upvoted 0 times

Chun

1 year ago

C) Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.

upvoted 0 times

...

Alaine

1 year ago

B) Use the default configuration for the automated backups location.

upvoted 0 times

...

Kimberely

1 year ago

A) Configure the automated backups to use a regional Cloud Storage bucket as a custom location.

upvoted 0 times

...

Carli

1 year ago

B is the safest option, but it might not be the most cost-effective. Gotta weigh the pros and cons here.

upvoted 0 times

...

Shalon

1 year ago

A is the way to go! Minimizing costs and effort is key, and a regional Cloud Storage bucket is the perfect solution.

upvoted 0 times

Vincent

1 year ago

Let's go ahead and configure the automated backups to use a regional Cloud Storage bucket.

upvoted 0 times

...

Luis

1 year ago

It's definitely the most cost-effective and efficient choice.

upvoted 0 times

...

Helene

1 year ago

Agreed, using a regional Cloud Storage bucket for automated backups makes sense.

upvoted 0 times

...

Paris

1 year ago

I think we should go with option A.

upvoted 0 times

...

Jennifer

2 years ago

I think option D could be a good alternative, it's more efficient.

upvoted 0 times

...

Victor

2 years ago

I prefer option C, it gives us more control over the backups.

upvoted 0 times

...

Elmira

2 years ago

I agree with Bulah, option A seems like the best choice.

upvoted 0 times

...

Bulah

2 years ago

I think we should go with option A.

upvoted 0 times

...