Google Cloud Professional Cloud Database Engineer — Question 75

You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

Answer options

• A. Place the bulk of the read and write workloads closer to the default leader region.
• B. Use staleness of at least 15 seconds.
• C. Add more read-write replicas.
• D. Keep the total CPU utilization under 45% in each region.

Correct answer: A

Explanation

Option A is correct because placing workloads closer to the default leader region minimizes latency and improves performance in a multi-regional instance. Option B does not address the performance issue effectively as increased staleness can lead to outdated data. Option C may help with read performance but does not necessarily speed up write operations. Option D focuses on CPU utilization, which may not directly correlate with the write workload performance.