SQL Practice Logo

SQLPractice Online

Level 7 - ArchitectScenario-Based Questionsm3 partitioning lifecycle

Scenario: Multi-Tenant Partitioning by Time + Tenant

You have 5k tenants with highly skewed traffic. How do you partition and index to avoid hot partitions?

Schema Context

events(event_id, tenant_id, event_time, event_type)