Discuss Google Professional Cloud Database Engineer Exam Topic 1 Question 44

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.

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

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

34 comments · newest first

Laquanda 11 months ago

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

Francisca 11 months ago

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

Desirae 11 months ago

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

Delbert 11 months ago

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

Gertude 12 months ago

Option B is the best choice for high availability.

Nakisha 12 months ago

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

Tien 1 year 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.

Alberta 1 year 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.

Emerson 1 year ago

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

Florinda 1 year ago

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

Vincenza 1 year 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.

Omega 1 year ago

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

Janessa 1 year 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.

Halina 1 year ago

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

Olene 1 year 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.

Miesha 1 year ago

↳ replying to Olene

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.

Hortencia 1 year ago

↳ replying to Olene

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

Glendora 1 year ago

↳ replying to Olene

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

Annice 1 year 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!

Vanna 1 year ago

Option D is overkill. Creating two read-write instances in different regions is unnecessary for this use case. B is the most efficient solution.

Bronwyn 1 year ago

↳ replying to Vanna

Let's go with creating one regional Cloud SQL instance in one zone with a standby instance in another zone.

Josefa 1 year ago

↳ replying to Vanna

Having a standby instance in another zone in the same region is a good idea.

Marya 1 year ago

↳ replying to Vanna

I agree, option D seems like overkill.

Shannan 1 year ago

↳ replying to Vanna

I think option B is the most efficient solution.

Lawana 1 year ago

I agree with Celia. Having a standby instance in a different zone provides the redundancy and automatic failover that the application team needs.

Portia 1 year ago

↳ replying to Lawana

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

Avery 1 year ago

↳ replying to Lawana

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

Felton 1 year ago

↳ replying to Lawana

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

Celia 2 years ago

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

Lorrine 1 year ago

↳ replying to Celia

Agreed, having a regional instance with a standby in another zone is a solid setup.

Ashlee 1 year ago

↳ replying to Celia

I think option B is the best choice for high availability.

Tuyet 2 years ago

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

Mariann 2 years ago

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

Tuyet 2 years ago

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

Google Professional Cloud Database Engineer Exam - Topic 1 Question 44 Discussion