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

Olene

27 days ago

Hmm, I wonder if the app team has considered the potential latency issues with a multi-region setup. A regional instance with a local standby seems like the way to go.

upvoted 0 times

Miesha

3 days ago

Hmm, I wonder if the app team has considered the potential latency issues with a multi-region setup. A regional instance with a local standby seems like the way to go.

upvoted 0 times

...

Hortencia

14 days ago

B) Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

upvoted 0 times

...

Glendora

15 days ago

A) Create one regional Cloud SQL instance with a read replica in another region.

upvoted 0 times

...

Annice

29 days ago

Haha, I bet the application team is hoping for zero downtime. Good thing they're not asking for 99.999% uptime, or they'd have to build a whole data center underground!

upvoted 0 times

...