
Answer-first summary for fast verification
Answer: Use zonal Cloud SQL without high availability (HA).
To minimize write latency for a new web application in one region, the best approach is to use a database solution that is optimized for low latency writes within that region. Option A suggests using Cloud SQL with cross-region replicas, which would actually increase write latency due to the need to replicate data across regions. Option B proposes high availability (HA) Cloud SQL with multiple zones, which improves availability but does not necessarily minimize write latency as it involves synchronous replication across zones. Option C, using zonal Cloud SQL without high availability (HA), is the most straightforward approach to minimize write latency because it avoids the overhead of synchronous replication across zones or regions, focusing all resources within a single zone. Option D, using Cloud Spanner in a regional configuration, is designed for global distribution and strong consistency, which might not be necessary for minimizing write latency in a single region and could introduce unnecessary complexity and cost. Therefore, the correct answer is C, as it directly addresses the requirement to minimize write latency by avoiding the overhead of replication.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How can you design a database strategy for a new web application in a single region to minimize write latency?
A
Use Cloud SQL with cross-region replicas.
B
Use high availability (HA) Cloud SQL with multiple zones.
C
Use zonal Cloud SQL without high availability (HA).
D
Use Cloud Spanner in a regional configuration.