Google Professional Data Engineer
Comments
Loading comments...
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?
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.