Cloud Sql Cross Region Dr Switchover Failover Topology

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.

A financial data enterprise runs an OLTP database on Cloud SQL Enterprise Plus with high availability (HA) enabled in its primary region. To meet regulatory compliance, the architecture requires cross-region disaster recovery (DR) capabilities with minimal impact on production write latency during normal operations, routine zero-data-loss DR drill testing, and automated routing via a DNS write endpoint.

Which replication and failover topology should the data engineering team configure?

Configure dual-region synchronous replication across both regions using Cloud SQL regional high availability settings, and execute routine drills by stopping the primary instance.

Create a standard cross-region read replica, detach and promote the replica during drills, and run reverse transaction scripts to restore the original primary.

Designate a cross-region read replica as a DR replica using a cascadable configuration, execute routine drills via switchover operations, and invoke replica failover in an actual regional outage.

Deploy an active-active dual-primary Cloud SQL configuration across both regions using reverse change data capture (CDC) pipelines to maintain zero replication lag.

Professional Cloud Data Engineer

Cloud Sql Cross Region Dr Switchover Failover Topology

Related questions