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 Cloud Database Engineer Exam - Topic 8 Question 55 Discussion

You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?
A) Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
B) Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
C) Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
D) Configure the primary, standby, and read replica instances in zone A, all in the same region.

Google Professional Cloud Database Engineer Exam - Topic 8 Question 55 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 55
Topic #: 8
[All Professional Cloud Database Engineer Questions]

You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: A

https://cloud.google.com/sql/docs/postgres/high-availability#failover-overview


by Lilli at Apr 04, 2025, 06:51 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Brandee
9 months ago
A sounds solid, but I’m not sure about the zone distribution.
upvoted 0 times
...
Willie
9 months ago
I think C might be better for disaster recovery.
upvoted 0 times
...
Elroy
9 months ago
Wait, can you really have instances in different regions?
upvoted 0 times
...
Louvenia
9 months ago
Definitely not D, that’s just asking for trouble.
upvoted 0 times
...
Gladys
9 months ago
Option A is the way to go for high availability!
upvoted 0 times
...
Whitney
10 months ago
I recall a similar question where we had to choose zones for redundancy. I think option B might not be ideal since it puts both primary and standby in the same zone.
upvoted 0 times
...
Eleonora
10 months ago
I’m a bit confused about the regions. I thought having the standby in a different region could be beneficial, but I’m not sure if that’s the best practice here.
upvoted 0 times
...
Antonio
10 months ago
I think option A sounds right because it spreads the instances across different zones, which is what we practiced in class.
upvoted 0 times
...
Rikki
10 months ago
I remember that high availability setups usually require instances in different zones, but I'm not sure if they should all be in the same region.
upvoted 0 times
...
Hobert
11 months ago
I'm feeling pretty confident about this one. The answer is B - configure the primary and standby instances in zone A and the read replica in zone B, all in the same region. That way, we get high availability and can still maintain low latency for the read replica.
upvoted 0 times
...
Arlene
11 months ago
Okay, I've got this. Based on the question, the best approach is to configure the primary and standby instances in different zones within the same region, and then add a read replica in a separate zone. That way, we have redundancy and can handle zone-level failures.
upvoted 0 times
...
Paola
11 months ago
Hmm, I'm a bit confused. I know we need to ensure high availability, but I'm not sure if we should put the instances in different regions or just different zones within the same region. I'll need to review the Google documentation again.
upvoted 0 times
...
Elinore
11 months ago
This seems pretty straightforward. I think the key is to follow Google's recommended practices for high availability, which means spreading the instances across different zones and regions.
upvoted 0 times
...
Lonna
1 year ago
Option A sounds like a good compromise, but I think B is the clear winner here. Separating the read replica from the primary and standby is a smart move.
upvoted 0 times
...
Cary
1 year ago
Haha, option D is like putting all your eggs in one basket! I'll have to go with B, it's the Google-recommended practice and makes the most sense.
upvoted 0 times
Ira
1 year ago
Let's go with B then, better safe than sorry.
upvoted 0 times
...
Socorro
1 year ago
I agree, Google probably knows best when it comes to high availability.
upvoted 0 times
...
Yvonne
1 year ago
Yeah, option D does seem risky. B sounds like the safer choice.
upvoted 0 times
...
...
Valentine
1 year ago
But Google recommends having primary and standby instances in different zones for high availability, so I still think option A is the way to go.
upvoted 0 times
...
Lajuana
1 year ago
D is a no-go. Putting all the instances in the same zone defeats the purpose of high availability. I agree with B - that's the simplest and most effective solution.
upvoted 0 times
Polly
1 year ago
D) Configure the primary, standby, and read replica instances in zone A, all in the same region.
upvoted 0 times
...
Catina
1 year ago
B) Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
upvoted 0 times
...
Marsha
1 year ago
A) Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.
upvoted 0 times
...
...
Noel
1 year ago
Option C seems like overkill to me. Why spread the instances across multiple regions when you can get high availability within a single region? I'd go with option B.
upvoted 0 times
Jaclyn
1 year ago
Let's go with option B then. It's the most practical choice.
upvoted 0 times
...
Gilma
1 year ago
That's a good point. Option B does provide high availability within the same region.
upvoted 0 times
...
Glory
1 year ago
But wouldn't it be safer to have them in different zones within the same region?
upvoted 0 times
...
Johnna
1 year ago
I agree, spreading across multiple regions seems unnecessary.
upvoted 0 times
...
...
Gerry
1 year ago
I disagree, I believe option B is the best choice.
upvoted 0 times
...
Ashanti
1 year ago
I think option B is the way to go. Keeping the primary and standby in the same region ensures low latency, while the read replica in a different zone provides some geographic diversity.
upvoted 0 times
Ricarda
1 year ago
I think we should go with option C then, to ensure our database is highly available across different regions.
upvoted 0 times
...
Adelina
1 year ago
That's a good point, maybe option C would be the best choice for maximum high availability.
upvoted 0 times
...
Mignon
1 year ago
But wouldn't it be better to have the read replica in a different region for even more redundancy?
upvoted 0 times
...
Katie
1 year ago
I agree, option B sounds like a good balance between low latency and geographic diversity.
upvoted 0 times
...
Detra
1 year ago
In that case, option B might be the best compromise for our setup.
upvoted 0 times
...
Joana
1 year ago
That's true, but having the primary and standby in the same region can help with failover scenarios.
upvoted 0 times
...
Ula
1 year ago
But wouldn't it be better to spread the instances across different regions for better high availability?
upvoted 0 times
...
Janine
1 year ago
I agree, option B seems like a good balance between low latency and geographic diversity.
upvoted 0 times
...
...
Valentine
1 year ago
I think we should go with option A.
upvoted 0 times
...

Save Cancel