PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #85
You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?
The correct answer is D. Use Cloud Spanner in a regional configuration. Cloud Spanner in a regional configuration is optimized for low-latency, high-throughput writes within a single region. Its architecture uses Paxos consensus within the region to commit writes quickly while still guaranteeing strong consistency and high availability. Cloud SQL…
Question
You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?
Options
- AUse Cloud SQL with cross-region replicas.
- BUse high availability (HA) Cloud SQL with multiple zones.
- CUse zonal Cloud SQL without high availability (HA).
- DUse Cloud Spanner in a regional configuration.
How the community answered
(21 responses)- A19% (4)
- B5% (1)
- C5% (1)
- D71% (15)
Explanation
Cloud Spanner in a regional configuration is optimized for low-latency, high-throughput writes within a single region. Its architecture uses Paxos consensus within the region to commit writes quickly while still guaranteeing strong consistency and high availability. Cloud SQL with cross-region replicas (A) adds network round-trip latency to remote regions, increasing write latency. HA Cloud SQL with multiple zones (B) incurs additional latency for synchronous writes to the standby replica in another zone. Zonal Cloud SQL without HA (C) has low latency but is a single point of failure-not suitable for a production application-and is not a Google-recommended practice.
Topics
Community Discussion
No community discussion yet for this question.