You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica…

Question

Options

• AConfigure the primary instance in zone A, the standby instance in zone C, and the read replica in
• BConfigure the primary and standby instances in zone A and the read replica in zone B, all in the
• CConfigure the primary instance in one region, the standby instance in a second region, and the
• DConfigure the primary, standby, and read replica instances in zone A, all in the same region.

• A
  84% (54)
• B
  5% (3)
• C
  3% (2)
• D
  8% (5)

Explanation

The correct answer is A. For Cloud SQL high availability, Google's recommendation is to place the primary and standby instances in different zones within the same region. This ensures automatic failover if a zone goes down, while keeping replication latency low. The read replica can be placed in a separate zone (or region) for additional read scaling. Option B violates HA best practices by co-locating the primary and standby in the same zone - if that zone fails, both are lost. Option C places the standby in a different region, which is not how Cloud SQL HA (regional HA) is designed; standby must be in the same region. Option D places all three in the same zone, providing no fault tolerance.

No community discussion yet for this question.