Explanation:
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.
For more details, refer to the GCP documentation on Cloud SQL High Availability.
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.