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.
Option C is the correct answer. This approach involves creating a highly available Cloud SQL instance in region A and a highly available read replica in region B. Scaling up read workloads by creating cascading read replicas in multiple regions ensures that read traffic is distributed and managed effectively. In the event of a regional outage in region A, promoting the highly available read replica in region B ensures low RTO and RPO while minimizing interruptions to the readers. Option A involves restoring from a backup, which is time-consuming. Option B does not ensure high availability in multiple regions, and Option D does not consider multiple region availability and only relies on failover within the same region.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are tasked with deploying a MySQL database workload onto Google Cloud's managed database service, Cloud SQL. This database deployment has several critical requirements: it must be scalable to support multiple readers originating from diverse geographic regions, it must maintain high availability, and it must adhere to strict low Recovery Time Objective (RTO) and Recovery Point Objective (RPO) parameters. Additionally, the system should minimize disruptions to readers even during a failover event, such as a regional outage. What actions should you take to meet these objectives?
A
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. 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.
B
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.
C
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.
D
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.