SQL Practice Logo

SQLPractice Online

Level 6 - ExpertScenario-Based Questionsm2 performance schema

Scenario: Time-Series Event Storage

Design DDL for `sensor_events` expected to ingest 500M rows/month, queried by `tenant_id` and event_time windows. Include partition and index strategy in SQL.