Scenario: Fast Tenant Purge

Interviewer prompt: You must purge all data for one tenant_id quickly from a very large multi-tenant events table. Propose SQL-first design approach using partitioning.

events(event_id, tenant_id, event_ts, payload)