Question

Difficulty: EasyDisaster Recovery and Business Continuity Execution

An organization is executing its disaster recovery strategy for a critical application. The business requires a Recovery Point Objective (RPO) of zero, meaning no data loss can be tolerated during a complete regional outage. Which Google Cloud database strategy meets this requirement?

  1. Cloud Spanner deployed with a multi-region configurationAnswer
  2. B
    Cloud SQL for PostgreSQL with an asynchronous cross-region read replica
  3. C
    Cloud SQL with automated daily exports to a Cloud Storage multi-region bucket
  4. D
    Compute Engine persistent disk snapshots transferred over a Dedicated Interconnect connection

Answer

Cloud Spanner deployed with a multi-region configuration provides synchronous cross-region replication and guarantees zero RPO during a regional disaster.
Cloud Spanner multi-region configurations utilize Paxos consensus to perform synchronous writes across multiple regions. This guarantees strong transactional consistency and zero data loss (RPO = 0) even during a complete regional outage.

Step-by-Step Solution

1
Identify key disaster recovery constraint
The requirement specifies an RPO of zero (no data loss tolerated).
Zero RPO requires synchronous data replication across geographic regions.
2
Evaluate GCP database replication capabilities
Cloud Spanner multi-region deployments use Paxos consensus for synchronous cross-region writes, whereas Cloud SQL cross-region replicas rely on asynchronous replication.
Asynchronous replication leaves uncommitted data vulnerable to data loss during sudden regional failures.
3
Select matching GCP solution pattern
Cloud Spanner multi-region is the correct architecture.
It natively delivers multi-region synchronous replication to guarantee zero RPO execution.

Key Concept

Multi-region disaster recovery execution with zero RPO using Cloud Spanner synchronous replication
Rate this question