Level 7 - ArchitectScenario-Based Questionsm3 partitioning lifecycle
Scenario: Retention Deletes vs Partition Drops
You must enforce 180-day retention on 12TB events data with minimal lock risk. Design approach.
Schema Context
events(event_id, tenant_id, event_time, payload)