M3 • Partitioning & Lifecycle
Level 7 - Architect - Partitioning & Lifecycle
Apply partitioning and data lifecycle design for performance: pruning, hot/cold storage, retention windows, and local/global index decisions.
Module Coverage
16 questions focused on interview-style decision making, trade-offs, and scalable SQL design.
range/hash/list partitioningpartition pruninghot-cold splitretention and archivalpartition index strategy