Question 80
The previous outage involved this problem: A company assumes its regional Cloud SQL HA standby protects it against total loss of the region. What long-term control addresses the risk?
Explanation
Correct Answer
Test regional disaster scenarios independently from within-region failover. The recurring risk is the DR plan confuses cross-zone HA with cross-region disaster recovery. This check makes that risk visible before another incident.
Incorrect Answers
This would evaluate AlloyDB using application-scale benchmark evidence rather than product positioning. It is useful when a high-throughput PostgreSQL-compatible analytics-heavy transactional application needs a managed service optimized for demanding reads, but it does not prevent the issue here: the DR plan confuses cross-zone HA with cross-region disaster recovery.
This control would record geographic availability and residency decisions before creating databases; it responds to the risk in which a document application requiring geographic resilience is deployed to a database location that meets only one region's risk model. It would not address the current root cause: the DR plan confuses cross-zone HA with cross-region disaster recovery.
The failure in the question arises because the DR plan confuses cross-zone HA with cross-region disaster recovery. A safeguard to monitor cross-cluster replication freshness against recovery objectives serves situations where a Bigtable team claims replication ensures data protection but never measures how late changes reach the alternate cluster rather than this one.