Level 7 - ArchitectScenario-Based Questionsm1 indexing strategy
Scenario: Multi-Tenant Events Index Strategy
events has 4B rows/year, heavy writes, 13-month retention. Common filters are tenant_id + event_time and sometimes event_type. Propose partition + index strategy, one trade-off, and one validation metric.
Schema Context
events(event_id, tenant_id, event_time, event_type, payload_json)