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?

The correct answer is A. Create a Cloud SQL instance in one zone, and create a failover replica in another zone within the same region.. Explanation/Reference: https://cloud.google.com/sql/docs/mysql/high-availability

Submitted by deeparc· Mar 30, 2026Designing data processing systems

Question

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?

Options

ACreate a Cloud SQL instance in one zone, and create a failover replica in another zone within the same region.
BCreate a Cloud SQL instance in one zone, and create a read replica in another zone within the same region.
CCreate a Cloud SQL instance in one zone, and configure an external read replica in a zone in a different region.
DCreate a Cloud SQL instance in a region, and configure automatic backup to a Cloud Storage bucket in the same region.

How the community answered

(20 responses)

A
85% (17)
B
10% (2)
D
5% (1)

Explanation

Explanation/Reference: https://cloud.google.com/sql/docs/mysql/high-availability

Topics

#Cloud SQL#high availability#failover replica#zone redundancy

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-DATA-ENGINEER Practice