Google Cloud Professional Cloud Database Engineer — Question 22

Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?

Answer options

• A. 1. 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.
• B. 1. 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.
• C. 1. 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.
• D. 1. 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.

Correct answer: B

Explanation

The correct answer is B because it provisions a Cloud SQL for MySQL instance in the primary region, creates a multiple-zone instance in the same primary region for redundancy, and sets up a read replica in the backup region to ensure data availability during a regional failure. The other options either place the multiple-zone instance in a different region or do not utilize the correct zones, which would not meet the requirements for fault tolerance.