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…

Question

Options

• 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
• CCreate two read-write Cloud SQL instances in two different zones with a standby instance in
• DCreate two read-write Cloud SQL instances in two different regions with a standby instance in

• A
  10% (2)
• B
  81% (17)
• C
  5% (1)
• D
  5% (1)

Explanation

Cloud SQL High Availability (HA) works by creating a primary instance in one zone and a standby instance in a different zone within the same region. If the primary fails, Cloud SQL automatically fails over to the standby. This is the Google-recommended HA pattern for Cloud SQL. A read replica in another region (A) does not provide automatic failover-it is read-only and meant for offloading reads. Options C and D describe 'two read-write instances,' which is not a valid Cloud SQL topology; Cloud SQL does not support active-active multi-primary configurations.

No community discussion yet for this question.