Answer-first summary for fast verification
Answer: Configure a Cloud SQL instance in one zone and establish a failover replica in another zone within the same region.
**Correct Answer: A** Creating a Cloud SQL instance in one zone and a failover replica in another zone within the same region ensures high availability during a zone failure. This setup allows the failover replica to automatically take over if the primary instance becomes unavailable, maintaining database accessibility. **Why Other Options Are Incorrect:** - **B:** A read replica in another zone within the same region does not offer automatic failover capabilities. Read replicas are designed for scaling read operations, not for high availability. - **C:** An external read replica in a different region is useful for disaster recovery or read scaling but does not provide automatic failover within the same region. - **D:** Automatic backups to a Cloud Storage bucket are beneficial for data recovery but do not ensure real-time failover during a zone failure.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are setting up Cloud SQL with MySQL to ensure high availability in the event of a zone failure. Which strategy should you implement to achieve this?
A
Configure a Cloud SQL instance in one zone and establish a failover replica in another zone within the same region.
B
Set up a Cloud SQL instance in one zone and create a read replica in another zone within the same region.
C
Deploy a Cloud SQL instance in one zone and set up an external read replica in a different region.
D
Install a Cloud SQL instance in a region and enable automatic backups to a Cloud Storage bucket in the same region.
No comments yet.