Whenever you're ready, walk me through how you'd approach this.
Describe how you would implement data partitioning and indexing in a large dataset.
Explain how you would choose partition keys, design indexes, avoid excessive small partitions, and validate query performance. Discuss trade-offs for batch loads, incremental updates, data skew, partition maintenance, and changing query patterns.