Answer-first summary for fast verification
Answer: 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.
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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
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?
A
B
C
D
No comments yet.