Question 830
A high-frequency session-state table incurs latch contention during short key-value transactions. The team proposes this approach: Pilot a supported memory-optimized table design and benchmark transaction outcomes. Which technical principle supports this approach?
Explanation
Correct Answer
Memory-optimized tables can reduce some locking/latching overhead in supported workloads. Memory-optimized features have compatibility and capacity limits.
Incorrect Answers
An in-memory design targets specific contention modes; wait profiling and representative benchmarks must justify it.
Memory-optimized OLTP has configuration and capability constraints; choose durability based on business recovery needs.
Memory-optimized solutions still need capacity, index, operation and recovery testing under peak workloads.