MENU
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?
Suggested Answer: A
Get Premium Professional Cloud Database Engineer Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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.
36 comments · newest first
AU
Audra
11 months ago
Wait, can you really disable automated backups? That sounds sketchy!
DE
Deeanna
11 months ago
D seems like overkill for just backups, right?
EL
Elbert
11 months ago
C sounds risky, manual backups can be a hassle!
RA
Rasheeda
11 months ago
I think B is fine too, but it might not be as flexible.
AN
Anjelica
12 months ago
A is the best choice for compliance and cost-efficiency.
OD
Odelia
12 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.
EL
Elmer
1 year 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.
MA
Margarett
1 year 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.
RU
Rutha
1 year 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.
EL
Elise
1 year 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.
CA
Carli
1 year 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.
OR
Oretha
1 year 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.
RO
Rosalind
1 year 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.
EL
Elza
1 year 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.
DO
Doug
1 year 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.
CH
Cheryl
2 years ago
Wait, we're supposed to _minimize_ costs? I thought this was the cloud, where the sky's the limit!
JU
Julio
2 years ago
D) Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.
JO
Josephine
2 years ago
Wait, we're supposed to _minimize_ costs? I thought this was the cloud, where the sky's the limit!
DI
Diane
2 years ago
C) Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.
GE
Geraldo
2 years ago
A) Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
DU
Dudley
2 years ago
Hey, at least it's not a NoSQL database, am I right? Those things are a whole other can of worms!
MI
Mitsue
2 years 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.
MA
Marlon
2 years ago
D sounds interesting, but I'm not sure about the whole 'serverless' thing. Might be a bit over my head.
CH
Chun
2 years ago
C) Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.
AL
Alaine
2 years ago
B) Use the default configuration for the automated backups location.
KI
Kimberely
2 years ago
A) Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
CA
Carli
2 years ago
B is the safest option, but it might not be the most cost-effective. Gotta weigh the pros and cons here.
SH
Shalon
2 years ago
A is the way to go! Minimizing costs and effort is key, and a regional Cloud Storage bucket is the perfect solution.
VI
Vincent
2 years ago
Let's go ahead and configure the automated backups to use a regional Cloud Storage bucket.
LU
Luis
2 years ago
It's definitely the most cost-effective and efficient choice.
HE
Helene
2 years ago
Agreed, using a regional Cloud Storage bucket for automated backups makes sense.
PA
Paris
2 years ago
I think we should go with option A.
JE
Jennifer
2 years ago
I think option D could be a good alternative, it's more efficient.
VI
Victor
2 years ago
I prefer option C, it gives us more control over the backups.
EL
Elmira
2 years ago
I agree with Bulah, option A seems like the best choice.
BU
Bulah
2 years ago
I think we should go with option A.