Examkin

Question

Difficulty: MediumDesigning Infrastructure for Technical Requirements and High Availability

A global media organization is architecting a core video metadata management service on Google Cloud. The system requires a relational database that can support strong consistency, zero Recovery Point Objective (RPO=0RPO = 0), and continuous multi-region high availability with a 99.999%99.999\% uptime Service Level Objective (SLOSLO) during regional outages. Which database architecture best satisfies these technical availability and disaster recovery requirements with minimal operational management?

  1. Provision a multi-region Cloud Spanner instance across target GCP regions.Answer
  2. B
    Provision a Cloud SQL for PostgreSQL instance with High Availability (regional multi-zone) and cross-region read replicas.
  3. C
    Deploy a Google Kubernetes Engine (GKE) cluster running self-managed PostgreSQL with asynchronous replication to a warm standby region.
  4. D
    Establish HA VPN connections between two regions and deploy dual-active Cloud SQL instances using third-party replication scripts.

Answer

Provision a multi-region Cloud Spanner instance across target GCP regions.
Cloud Spanner multi-region configurations deliver fully managed, globally distributed relational transactions with strong consistency and external consistency (TrueTime API). Multi-region Spanner configurations natively provide a 99.999% SLA and automatic synchronous multi-region failover, fulfilling the zero RPO requirement during a regional outage without requiring application-level failover logic.

Step-by-Step Solution

1
Analyze the technical requirements
Identified requirements: relational schema, strong consistency, zero RPO (RPO=0RPO = 0), multi-region high availability (99.999%99.999\% availability), and minimal operational overhead.
Matching database capabilities directly against SLA/SLO and DR constraints is necessary to select the correct GCP managed service.
2
Evaluate regional vs multi-region database capabilities in Google Cloud
Cloud SQL HA is regional (multi-zone) with 99.95% SLA and asynchronous cross-region replication. Cloud Spanner Multi-Region offers built-in synchronous replication across regions with 99.999% SLA and zero RPO failover.
Cloud Spanner uses TrueTime and Paxos consensus to achieve external consistency and synchronous cross-region writes.
3
Select the optimal architecture
Cloud Spanner multi-region instance satisfies all uptime, consistency, and RPO requirements natively.
Avoids custom scripts, manual failover procedures, or data loss associated with asynchronous replication.

Key Concept

Multi-Region High Availability & Consistency with Cloud Spanner
Rate this question

Topics

Designing Infrastructure for Technical Requirements and High Availability