Answer-first summary for fast verification
Answer: Create a failover replica instance in the same region, but in a different zone
The question asks how to implement high availability for a single-zone Cloud SQL instance. Based on Google Cloud documentation and community consensus, the correct approach is to create a failover replica in the same region but a different zone (Option D). This configuration provides automatic failover capabilities, ensuring minimal downtime during zone failures. Read replicas (Options A and C) are designed for scaling read operations and do not provide automatic failover for high availability. Cross-region replicas (Options A and B) are unnecessary for high availability within a region and introduce additional latency and cost. While some community comments note that failover replicas are legacy and replaced by regional persistent disks, the question's options reflect the terminology used when it was created, and D remains the best answer among the given choices for achieving high availability.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are using a single-zone Cloud SQL instance for your application and need to implement high availability. What should you do?
A
Create a read replica instance in a different region
B
Create a failover replica instance in a different region
C
Create a read replica instance in the same region, but in a different zone
D
Create a failover replica instance in the same region, but in a different zone
No comments yet.