A financial application requires a relational database with automatic failover to a standby in a different zone, with minimal configuration overhead. Which Cloud SQL configuration provides this?
Cloud SQL with High Availability (HA) configuration is the correct choice because it automatically provisions a standby instance in a different zone within the same region and uses synchronous replication to keep it current. When the primary fails, Cloud SQL detects the outage and automatically promotes the standby, typically within seconds, and the public IP address remains the same so existing applications can reconnect without code changes. This gives you a simple, managed, zone-redundant solution that meets the requirement for automatic failover with no application-level logic.
Why this answer
Cloud SQL's High Availability (HA) configuration provides automatic failover to a standby instance in a different zone using synchronous replication and a regional persistent disk. This meets the requirement for minimal configuration overhead because it is a built-in feature that requires no application-level logic or manual intervention.
Exam trap
Google Cloud often tests the misconception that a read replica can serve as a failover target, but read replicas use asynchronous replication and require manual promotion, making them unsuitable for automatic failover with minimal configuration.
How to eliminate wrong answers
Option A is wrong because a read replica is designed for read scaling, not automatic failover; it requires manual promotion and does not provide synchronous replication for zero data loss. Option C is wrong because Cloud Spanner is a globally distributed, horizontally scalable database that introduces significant configuration overhead and cost, not a minimal-configuration relational database for a single-region failover requirement. Option D is wrong because managing two separate Cloud SQL instances with application-level failover logic adds significant configuration overhead and defeats the purpose of minimal configuration, as it requires custom code for health checks, replication, and failover coordination.