Level 7 - ArchitectScenario-Based Questionsm3 partitioning lifecycle
Scenario: Hot/Cold Storage Split Strategy
Design table strategy where 95% queries hit last 30 days, but compliance needs 3-year history.
Schema Context
audit_events(event_id, event_time, actor_id, payload)