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

Noel

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

...

Gerry

13 days ago

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

upvoted 0 times

...

Ashanti

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

Janine

2 days ago

I agree, option B seems like a good balance between low latency and geographic diversity.

upvoted 0 times

...

Valentine

22 days ago

I think we should go with option A.

upvoted 0 times

...