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

Laquanda

4 months ago

I didn’t know standby instances could be in different zones!

upvoted 0 times

...

Francisca

4 months ago

Definitely going with B, it’s the standard setup for failover.

upvoted 0 times

...

Desirae

4 months ago

Wait, why would you need two read-write instances? Seems overkill.

upvoted 0 times

...

Delbert

4 months ago

I think A could work too, but not as reliable.

upvoted 0 times

...

Gertude

5 months ago

Option B is the best choice for high availability.

upvoted 0 times

...

Nakisha

5 months ago

Option D seems excessive with two read-write instances in different regions; I think we only need one standby for failover, right?

upvoted 0 times

...

Tien

5 months ago

I practiced a similar question where the focus was on regional setups, and I feel like option B aligns with that, but I’m still a bit confused about the zones.

upvoted 0 times

...

Alberta

5 months ago

I'm not entirely sure, but I remember something about read replicas not providing automatic failover, so maybe options A and C aren't the best choices.

upvoted 0 times

...

Emerson

5 months ago

I think option B sounds familiar because it mentions a standby instance in another zone, which is important for high availability.

upvoted 0 times

...

Florinda

5 months ago

Creating two read-write instances in different regions sounds like the most robust solution to me. I'll select option D.

upvoted 0 times

...

Vincenza

5 months ago

Hmm, I'm a bit unsure about the difference between a read replica and a standby instance. I'll need to review those concepts before deciding.

upvoted 0 times

...

Omega

5 months ago

This seems like a straightforward high availability question. I'll carefully read through the options and think about the key requirements.

upvoted 0 times

...

Janessa

6 months ago

Okay, I think I've got this. The key is to have redundancy across zones and regions to ensure high availability. I'll go with option B.

upvoted 0 times

...

Halina

6 months ago

The tricky part is identifying what's genuinely unique, not just a general problem. Option D sounds most cloud-specific to me.

upvoted 0 times

...

Olene

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

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

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

10 months ago

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

upvoted 0 times

...

Annice

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

...