Answer-first summary for fast verification
Answer: Configure High Availability (HA) for Cloud SQL and create a Failover replica in the same region but in a different zone.
Configuring High Availability (HA) for Cloud SQL and creating a Failover replica in the same region but in a different zone is the correct approach. This setup ensures data redundancy and automatic failover to the standby instance if the primary becomes unresponsive. Read replicas do not offer failover capabilities, and HA-configured instances must have their primary and secondary instances within the same region, not in different regions. For more details, refer to [Google Cloud SQL documentation](https://cloud.google.com/sql/docs/mysql/high-availability).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You've developed an application for production users, planning to use Cloud SQL for hosting critical user state data. To safeguard this data against zone failures, what's the best approach?
A
Configure High Availability (HA) for Cloud SQL and create a Failover replica in the same region but in a different zone.
B
Create a Read replica in the same region but in a different zone.
C
Create a Failover replica in the same region but in a different zone.
D
Configure High Availability (HA) for Cloud SQL and create a Failover replica in a different region.
No comments yet.