Sorting in System Design — Storage Layout as a Sort Decision

At the staff level, sorting questions often arrive as system design questions: 'Design the storage layout for a fact table that must support both time-range queries and user-level lookups efficiently.' The answer is a sorting strategy — and knowing how to articulate the tradeoffs is what the interviewer is evaluating. The Full Storage Layout Design Question