Google Professional Cloud Database Engineer

Get started today

Ultimate access to all questions.

Explanation:

To ensure the most fault-tolerant and highly available solution for the Cloud SQL for MySQL backend database, the strategy involves setting up a primary instance in the primary region (us-central1) with high availability (multiple-zone instance) and a read replica in the backup region (us-east1). This setup allows the database to survive both zonal and regional failures. Option B correctly implements this strategy by: 1. Provisioning the primary instance in us-central1-a, 2. Creating a multiple-zone instance in us-central1-b (which provides high availability within the primary region), and 3. Creating a read replica in us-east1-b (which provides disaster recovery in the backup region). The other options either misplace the multiple-zone instance or the read replica, not fully meeting the requirement for both zonal and regional fault tolerance.

Explanation:

Comments (0)

No comments yet.

How can you design a highly available and fault-tolerant solution for your organization's critical business application using Cloud SQL for MySQL, ensuring it can withstand both zonal and regional failures with us-central1 as the primary region and us-east1 as the backup region?

Exam-Like

Last updated: April 17, 2026 at 14:02

Provision a Cloud SQL for MySQL instance in us-central1-a. 2. Create a multiple-zone instance in us-west1-b. 3. Create a read replica in us-east1-c.

7.7%

Provision a Cloud SQL for MySQL instance in us-central1-a. 2. Create a multiple-zone instance in us-central1-b. 3. Create a read replica in us-east1-b.

71.8%

Provision a Cloud SQL for MySQL instance in us-central1-a. 2. Create a multiple-zone instance in us-east-b. 3. Create a read replica in us-east1-c.

15.4%

Provision a Cloud SQL for MySQL instance in us-central1-a. 2. Create a multiple-zone instance in us-east1-b. 3. Create a read replica in us-central1-b.

5.1%