Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Professional Data Engineer Exam - Topic 1 Question 10 Discussion

You plan to deploy Cloud SQL using MySQL. You need to ensure high availability in the event of a zone failure. What should you do?
C) Create a Cloud SQL instance in one zone, and configure an external read replica in a zone in a different region.
A) Create a Cloud SQL instance in one zone, and create a failover replica in another zone within the same region.
B) Create a Cloud SQL instance in one zone, and create a read replica in another zone within the same region.
D) Create a Cloud SQL instance in a region, and configure automatic backup to a Cloud Storage bucket in the same region.

Google Professional Data Engineer Exam - Topic 1 Question 10 Discussion

Actual exam question for Google's Professional Data Engineer exam
Question #: 10
Topic #: 1
[All Professional Data Engineer Questions]

You plan to deploy Cloud SQL using MySQL. You need to ensure high availability in the event of a zone failure. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Marvel at May 07, 2022, 06:51 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Trinidad
7 months ago
I thought external replicas were a good option, but maybe not for this?
upvoted 0 times
...
Meghan
7 months ago
Definitely not D, backups won't help during a zone outage.
upvoted 0 times
...
Antonio
8 months ago
Wait, can a read replica really handle a zone failure?
upvoted 0 times
...
Margret
8 months ago
I agree, failover replicas are key for zone failures!
upvoted 0 times
...
Antonette
8 months ago
Option A is the best choice for high availability.
upvoted 0 times
...
Larue
8 months ago
I practiced a question like this, and I feel like having a failover replica in another zone is the key to ensuring availability. So, A seems correct.
upvoted 0 times
...
Nan
8 months ago
I'm not entirely sure, but I remember something about read replicas not providing failover capabilities. So, maybe B isn't the best choice?
upvoted 0 times
...
Rossana
8 months ago
I think option A sounds right because it mentions a failover replica, which is crucial for high availability.
upvoted 0 times
...
Chauncey
8 months ago
Option D seems tempting with backups, but I don't think it addresses high availability directly. I might lean towards A as well.
upvoted 0 times
...
Charlette
8 months ago
Hmm, I'm not sure about this one. I'll have to think it through carefully.
upvoted 0 times
...
Maybelle
8 months ago
This question seems a bit tricky. I'll need to think carefully about the relationship between the employee who was passed over and their potential resentment.
upvoted 0 times
...
Chauncey
8 months ago
I'm a bit confused by the wording of the question. Let me re-read it a couple times to make sure I understand what they're asking.
upvoted 0 times
...

Save Cancel