Google Exam Professional Cloud Database Engineer 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

Lonna

19 days 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

21 days 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

Yvonne

2 days ago

Yeah, option D does seem risky. B sounds like the safer choice.

upvoted 0 times

...

Valentine

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

Catina

16 hours 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

20 days 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 months 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

Gilma

15 hours ago

That's a good point. Option B does provide high availability within the same region.

upvoted 0 times

...

Glory

15 days ago

But wouldn't it be safer to have them in different zones within the same region?

upvoted 0 times

...

Johnna

21 days ago

I agree, spreading across multiple regions seems unnecessary.

upvoted 0 times

...

Gerry

2 months ago

I disagree, I believe option B is the best choice.

upvoted 0 times

...

Ashanti

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