PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #141: Real Exam Question with Answer & Explanation

Question

You are building the database layer for a multinational ticketing marketplace on Google Cloud. Traffic is unpredictable and can spike by 8x during global presales and seasonal campaigns. The system must deliver strongly consistent transactions, sub second reads for users on three continents, and a 99.999% availability target while still keeping spend under control. Which Google Cloud database service and configuration should you choose to meet these goals?

Options

• ACloud Bigtable with multi-cluster replication across two regions
• BCloud SQL for PostgreSQL with regional HA and cross-region read replicas using SSD
• CCloud Spanner with multi-regional configuration and SSD storage
• DCloud Firestore in Native mode with regional configuration

Explanation

Cloud Spanner meets the requirement for strongly consistent transactions through externally consistent reads and writes, which allows you to process OLTP workloads without violating correctness during spikes. The multi-regional configuration provides a five nines availability target through synchronous replication and automatic failover, which aligns with the 99.999 percent requirement. SSD storage underpins low latency performance. For users on three continents, a global multi-region such as a configuration that spans North America, Europe, and Asia enables sub second reads from nearby replicas using bounded staleness, while transactions remain strongly consistent by committing through the leader. Cloud Spanner also scales horizontally and can use processing units and compute autoscaling so you can expand capacity during 8x surges and reduce it when demand subsides to help keep spend

No community discussion yet for this question.