professional-cloud-data-engineer
Prepare and test your skills
Prepare and test your skills
Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.
An enterprise runs an online transaction processing (OLTP) database on Cloud SQL in us-central1. The engineering team is designing a disaster recovery (DR) and global read-scaling architecture for downstream analytics and regional services located in europe-west1.
The architecture must satisfy the following criteria:
Which strategy should the data engineering team implement?
Cloud SQL cross-region read replicas enable asynchronous replication of relational data across distinct Google Cloud regions. This architecture serves a dual purpose: localizing read traffic to geographically distributed clients and serving as a warm standby failover target for disaster recovery (DR).
StudyCerts
StudyCertseurope-west1 establishes an independent regional copy that can be promoted to a standalone primary database in the event of a regional outage in us-central1, achieving stringent RTO and RPO objectives.europe-west1 replica eliminates repetitive inter-region network egress charges from us-central1 to Europe and drastically reduces read latency for European users.Locating a properly sized read replica in the destination region balances disaster recovery readiness with localized query performance while explicitly addressing the root causes of replication lag.
Keep the momentum going with these hand-picked practice scenarios
Want more questions like this?
Get a free certification question every week.