Google Professional Data Engineer
Get started today
Ultimate access to all questions.
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?
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?
Explanation:
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.