A financial services company must run a PostgreSQL database with strong consistency across three regions. They need to support high write throughput and require automatic failover with zero data loss. Which database service should they choose?
Cloud Spanner provides externally consistent reads and writes globally through TrueTime, synchronising clocks via GPS and atomic clocks. Its synchronous replication across regions guarantees zero recovery point objective, satisfying the zero data loss constraint, while horizontal sharding supports the required high write throughput with automatic regional failover.
Why this answer
Cloud Spanner is Google Cloud's globally distributed, strongly consistent relational database that supports horizontal scaling for high write throughput and provides automatic failover with zero data loss (RPO=0) via synchronous replication. It is the only option that meets all requirements across three regions.
Exam trap
PCA often tests the trade-off between consistency and availability; candidates may pick Cloud SQL for PostgreSQL familiarity, but only Spanner offers global strong consistency with zero data loss.
How to eliminate wrong answers
Option A is wrong because AlloyDB is regional and does not provide multi-region strong consistency with automatic failover. Option B is wrong because Bigtable is a NoSQL wide-column store, not relational, and does not offer strong consistency across regions for transactions. Option C is wrong because Cloud SQL cross-region replication is asynchronous, leading to potential data loss on failover, and does not support high write throughput across regions.