Answer-first summary for fast verification
Answer: Create a failover replica instance in the same region, but in a different zone
The correct answer is D: Create a failover replica instance in the same region, but in a different zone. High availability (HA) in Cloud SQL is achieved through a regional configuration, which includes a primary instance and a standby instance in different zones within the same region. This setup ensures that if the primary instance fails or becomes unresponsive, the system can automatically failover to the standby instance with minimal downtime. Other options, such as creating a read replica, do not provide HA as read replicas are primarily used for scaling read operations and do not include automatic failover mechanisms.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are currently using a single Cloud SQL instance to serve your application, which is located in a specific zone. Your goal is to ensure high availability for your application to minimize downtime in case of failures. Considering best practices in Cloud SQL setup, 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.