SQL Practice Logo

SQLPractice Online

Level 10 - MasterScenario-Based Questionsm4 platform performance capacity strategy

Scenario: Hot Partition Mitigation Plan

One hash partition receives 60% of writes due to skewed tenant activity. Propose mitigation without downtime and with rollback safety.

Schema Context

events(event_id, tenant_id, event_time, payload) partitioned by hash(tenant_id)