Google Cloud Professional Cloud Database Engineer — Question 117

You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?

Answer options

• 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.

Correct answer: C

Explanation

The correct choice is C because using zonal Cloud SQL without high availability minimizes write latency by keeping all data in a single zone, which reduces network overhead. Options A and B introduce additional complexity and latency due to cross-region replication and multi-zone configurations. Option D, while scalable, is not the optimal choice for minimizing write latency in a single region scenario.