Answer-first summary for fast verification
Answer: Create a highly available Cloud SQL instance in region A. Create a highly available read replica in region B. Scale up read workloads by creating cascading read replicas in multiple regions. Promote the read replica in region B when region A is down.
The correct answer is B: Create a highly available Cloud SQL instance in region A. Create a highly available read replica in region B. Scale up read workloads by creating cascading read replicas in multiple regions. Promote the read replica in region B when region A is down. This approach ensures high availability, low RTO and RPO, and minimal interruptions to readers during a database failover in a multi-region deployment scenario. It provides geographic redundancy and a clear failover strategy, unlike the other options which either lack geographic redundancy or a straightforward failover mechanism.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are migrating a MySQL database workload to Cloud SQL. The database needs to scale to accommodate multiple readers from different geographic locations and maintain high availability with low RTO and RPO, especially during a regional outage. How can you minimize interruptions for readers during a database failover in this scenario?
A
Create a highly available Cloud SQL instance in region A. Scale up read workloads by creating read replicas in multiple regions. Promote one of the read replicas when region A is down.
B
Create a highly available Cloud SQL instance in region A. Create a highly available read replica in region B. Scale up read workloads by creating cascading read replicas in multiple regions. Promote the read replica in region B when region A is down.
C
Create a highly available Cloud SQL instance in region A. Scale up read workloads by creating read replicas in the same region. Failover to the standby Cloud SQL instance when the primary instance fails.
D
Create a highly available Cloud SQL instance in region Create a highly available read replica in region B. Scale up read workloads by creating cascading read replicas in multiple regions. Backup the Cloud SQL instances to a multi-regional Cloud Storage bucket. Restore the Cloud SQL backup to a new instance in another region when Region A is down.