Associate Data Practitioner

By Google · Question Mode

QuestionQ22

Data Management

You have a Cloud SQL for PostgreSQL database that holds sensitive historical financial data. You must ensure the data remains uncorrupted and can be recovered if the primary region is destroyed. Because the data is valuable, prioritize the recovery point objective (RPO) over the recovery time objective (RTO). You want to recommend a solution that minimizes latency for primary read and write operations. What should you do?

Explanation

Cloud SQL multi-region backups provide disaster-recovery capability for a regional outage while retaining the primary database in its local region, avoiding synchronous cross-region write latency. Cloud SQL high availability uses synchronous replication only between zones within the configured region, so it does not protect against loss of that entire region. Cross-region replicas replicate asynchronously and can lose recent committed transactions during a regional outage.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!