Google
PROFESSIONAL-DATA-ENGINEER · Question #318
You are deploying a MySQL database workload onto Cloud SQL. The database must be able to scale up to support several readers from various geographic regions. The database must be highly available and
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #318. The question stem and answer options stay visible for context.
Submitted by sofia.br· Mar 30, 2026Building and operationalizing data processing systems
Question
You are deploying a MySQL database workload onto Cloud SQL. The database must be able to scale up to support several readers from various geographic regions. The database must be highly available and meet low RTO and RPO requirements, even in the event of a regional outage. You need to ensure that interruptions to the readers are minimal during a database failover. What should you do?
Options
- ACreate 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
- BCreate 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
- CCreate 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
- DCreate 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
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Cloud SQL#Database High Availability#Read Replicas#Cross-Region Disaster Recovery