SQL Practice Logo

SQLPractice Online

Level 10 - MasterScenario-Based Questionsm4 platform performance capacity strategy

Scenario: Noisy Neighbor Isolation in Shared Cluster

A single tenant is saturating shared warehouse resources and degrading p95 latency for everyone else. Design isolation strategy with one fairness policy.

Schema Context

query_runs(run_id, tenant_id, queue, cpu_seconds, started_at)