Google Cloud Professional Cloud Architect — Question 90

You are using a single Cloud SQL instance to serve your application from a specific zone. You want to introduce high availability. What should you do?

Answer options

• A. Create a read replica instance in a different region
• B. Create a failover replica instance in a different region
• C. Create a read replica instance in the same region, but in a different zone
• D. Create a failover replica instance in the same region, but in a different zone

Correct answer: D

Explanation

The correct choice is D because a failover replica in the same region but in a different zone ensures that your database can switch over in case of a zone failure, providing high availability. Options A and B do not provide the necessary high availability within the same region, and option C, while it sets up a read replica, does not offer failover capabilities.