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?

AConfigure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.

BConfigure the primary and standby instances in zone A and the read replica in zone B, all in the same region.

CConfigure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.

DConfigure the primary, standby, and read replica instances in zone A, all in the same region.

Show Suggested 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:

Submit Cancel

Brandee

5 months ago

A sounds solid, but I’m not sure about the zone distribution.

upvoted 0 times

...

Willie

5 months ago

I think C might be better for disaster recovery.

upvoted 0 times

...

Elroy

6 months ago

Wait, can you really have instances in different regions?

upvoted 0 times

...

Louvenia

6 months ago

Definitely not D, that’s just asking for trouble.

upvoted 0 times

...

Gladys

6 months ago

Option A is the way to go for high availability!

upvoted 0 times

...

Whitney

6 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

7 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

7 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

7 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

7 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

7 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

8 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

8 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

11 months ago

Let's go with B then, better safe than sorry.

upvoted 0 times

...

Socorro

11 months ago

I agree, Google probably knows best when it comes to high availability.

upvoted 0 times

...

Yvonne

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

12 months ago

D) Configure the primary, standby, and read replica instances in zone A, all in the same region.

upvoted 0 times

...

Catina

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

12 months ago

Let's go with option B then. It's the most practical choice.

upvoted 0 times

...

Gilma

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