Answer-first summary for fast verification
Answer: Configure a Failover replica in the same region but 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 a primary instance in one zone and a failover replica in another zone within the same region, ensuring data redundancy through semisynchronous replication. In case of a failure, this configuration minimizes downtime, keeping your data accessible. - **Options A & B** are incorrect as Read replicas only offer additional read capacity without 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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A company relies on Cloud SQL for hosting critical data and seeks to ensure high availability in the event of 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
Set up a Read replica in a different region and zone.
C
Configure a Failover replica in the same region but a different zone.
D
Create a Failover replica in a different region and zone.
No comments yet.