Answer-first summary for fast verification
Answer: Create a Cloud SQL instance in one zone, and create a failover replica in another zone within the same region.
The correct answer is A. Creating a failover replica in another zone within the same region establishes a high-availability configuration. This ensures that if the primary instance fails, the failover replica can quickly take over, minimizing downtime and maintaining high availability. Google's legacy high-availability configuration used failover replicas, and although new configurations may use different methods, this option directly addresses the need for zone failure resilience within the same region.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are tasked with deploying a Cloud SQL instance using MySQL for your organization. Ensuring the high availability of this database is critical for your operations, especially in the event of a zone failure within Google's Cloud infrastructure. What steps should you take to ensure high availability for your Cloud SQL deployment?
A
Create a Cloud SQL instance in one zone, and create a failover replica in another zone within the same region.
B
Create a Cloud SQL instance in one zone, and create a read replica in another zone within the same region.
C
Create a Cloud SQL instance in one zone, and configure an external read replica in a zone in a different region.
D
Create a Cloud SQL instance in a region, and configure automatic backup to a Cloud Storage bucket in the same region.
No comments yet.