Google Cloud Professional Data Engineer — Question 41

You plan to deploy Cloud SQL using MySQL. You need to ensure high availability in the event of a zone failure. What should you do?

Answer options

• 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.

Correct answer: A

Explanation

Option A is correct because creating a failover replica in another zone within the same region ensures that the database can seamlessly switch to the replica during a zone failure, maintaining high availability. Options B and C do not provide the same level of high availability since read replicas do not support automatic failover. Option D only addresses backup and does not provide high availability during a zone failure.