Explanation:
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:
Ultimate access to all questions.
No comments yet.
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.