Answer-first summary for fast verification
Answer: Establish a Failover replica within the same region but in a different zone.
The correct answer is **C** because a failover replica is essential for providing High Availability (HA) for Cloud SQL. This setup involves creating a primary instance in one zone and a failover replica in a different zone within the same region. Semisynchronous replication ensures that all data and user table changes on the primary instance are mirrored on the failover replica, minimizing downtime during an instance or zone failure. - **Options A & B** are incorrect as Read replicas only offer additional read capacity and do not support failover capabilities. - **Option D** is incorrect because the failover replica must reside in the same region as the primary instance, albeit in a different zone. For more details, refer to the [GCP documentation on Cloud SQL High Availability](https://cloud.google.com/sql/docs/high-availability).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A company is utilizing Cloud SQL to host critical data and aims to enable high availability to safeguard against a complete zone failure. What is the recommended configuration to achieve this?
A
Establish a Read replica within the same region but in a different zone.
B
Establish a Read replica in a different region and a different zone.
C
Establish a Failover replica within the same region but in a different zone.
D
Establish a Failover replica in a different region and a different zone.