Question 23

Question

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?

Accepted Answer

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

Sean X. · Answer

I went with D. My reasoning is that having two write instances across regions plus a standby should boost both availability and potential for region-level failover, which seems optimal. Maybe I'm missing some Cloud SQL specifics about auto failover not working cross-region, but it feels like D covers more outages. Correct me if that's not how Google handles it!

Parker · Answer

C or D - saw some practice exams mention these when asking about availability across zones and regions. Official guide talks about failover setups but doesn't always clarify between regional vs cross-region HA. Maybe check the docs or the official Google study materials for exact requirements.

Quinn · Answer

Yup, it's B. Regional instance with standby in another zone covers HA and auto failover for Cloud SQL.

Jamie B. · Answer

Best setup for HA and automatic failover here is B.

Google Professional Cloud Database Engineer Real Exam Questions [October 2026 Update] Quiz

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?

Premium Access Includes