You are using a single Cloud SQL instance to serve your application from a specific zone. You want to introduce high availability. What should you do?
Choose an answer
Tap an option to check your answer.
Correct answer: Create a failover replica instance in the same region, but in a different zone.
Why this is the answer
Creating a failover replica instance in the same region but a different zone is the correct approach to introduce high availability for a single Cloud SQL instance. This configuration ensures that if the primary instance or its zone becomes unavailable, Cloud SQL can automatically fail over to the replica, minimizing downtime. Read replicas are for scaling read operations and do not provide automatic failover for the primary instance. Placing the failover replica in a different region would introduce higher latency for replication and failover, and is typically used for disaster recovery rather than high availability within a single region.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed