PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #184
Your company is using a multi-region Spanner instance. The instance stores data from an application which does a lot of writes without reading the data. You are noticing a lot of latency regression…
The correct answer is A. Enable leader-aware routing in the client library. Enabling leader-aware routing ensures that your write traffic is automatically sent to the database’s designated leader region rather than being round-tripped across regions. For a write- heavy workload in a multi-region configuration, this change cuts out cross-region hops and…
Question
Your company is using a multi-region Spanner instance. The instance stores data from an application which does a lot of writes without reading the data. You are noticing a lot of latency regression. You want to reduce latency and improve performance. What should you do-
Options
- AEnable leader-aware routing in the client library.
- BAdd additional indexes to the table.
- CDisable leader-aware routing in the client library.
- DIncrease the number of Spanner nodes.
How the community answered
(41 responses)- A73% (30)
- B15% (6)
- C5% (2)
- D7% (3)
Explanation
Enabling leader-aware routing ensures that your write traffic is automatically sent to the database’s designated leader region rather than being round-tripped across regions. For a write- heavy workload in a multi-region configuration, this change cuts out cross-region hops and lowers latency far more effectively than adding indexes or nodes.
Topics
Community Discussion
No community discussion yet for this question.