Explanation:
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.
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.