SQL Practice Logo

SQLPractice Online

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)