Google Exam Professional Cloud Database Engineer Topic 1 Question 44 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 44
Topic #: 1

[All Professional Cloud Database Engineer Questions]

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

ACreate one regional Cloud SQL instance with a read replica in another region.

BCreate one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

CCreate two read-write Cloud SQL instances in two different zones with a standby instance in another region.

DCreate two read-write Cloud SQL instances in two different regions with a standby instance in another zone.

Show Suggested Answer

Suggested Answer: D

Verify that the replica has processed all the transactions it has received from the primary. This ensures that when promoted, the replica reflects all transactions that were received before the primary became unavailable. https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#verify_failover_criteria

by Rosalyn at Sep 16, 2024, 01:16 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

Celia

9 days ago

Option B is the way to go! A regional instance with a standby in another zone is the perfect setup for high availability.

upvoted 0 times

...

Tuyet

12 days ago

That's a valid point, but having a standby instance in the same region like in option B can also provide quick failover.

upvoted 0 times

...

Mariann

13 days ago

I disagree, I believe option A is better as it offers a read replica in another region for better fault tolerance.

upvoted 0 times

...

Tuyet

24 days ago

I think option B is the best choice because it provides high availability within the same region.

upvoted 0 times

...