Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible…

Question

Options

• A
  1. Provision a Cloud SQL for MySQL instance in us-central1-a.
• B
  1. Provision a Cloud SQL for MySQL instance in us-central1-a.
• C
  1. Provision a Cloud SQL for MySQL instance in us-central1-a.
• D
  1. Provision a Cloud SQL for MySQL instance in us-central1-a.

• A
  13% (5)
• B
  79% (31)
• C
  5% (2)
• D
  3% (1)

Explanation

Surviving both a zonal and a regional failure requires two distinct mechanisms. For zonal failure protection, a Cloud SQL High Availability (HA) configuration is required - this creates a synchronous standby instance in a different zone within the same region (us-central1), enabling automatic failover if one zone goes down. For regional failure protection, a cross-region read replica must be provisioned in us-east1. Option B is the correct combination: an HA-enabled primary instance in us-central1 (for zonal resilience) plus a cross-region replica in us-east1 (for regional resilience). The other options likely omit either the HA configuration or the cross-region replica, leaving the solution vulnerable to one of the two failure scenarios.

No community discussion yet for this question.