Your question is Indexing and Partitioning Strategies. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
What are the differences between various data indexing and partitioning strategies?
Compare common index types and partitioning schemes, including their internal access patterns, write and storage costs, query benefits, and operational trade-offs. Use a concrete example to explain when you would choose one strategy over another, and distinguish indexing from partitioning.
Keep the answer focused on SQL databases and distributed analytical data platforms.
