Snapshot Isolation (SI)

Answer preview

Scenario questions test end-to-end design — clarify requirements, sketch architecture, deep-dive bottlenecks, and state trade-offs. Snapshot Isolation (SI) — define the concept, explain how it works in production, and call out trade-offs and failure modes.…