SQL Practice Logo

SQLPractice Online

Level 7 - ArchitectScenario-Based Questionsm3 partitioning lifecycle

Scenario: Backfill New Partition Key Without Downtime

Current table is unpartitioned at 20TB. Design migration to partitioned table with minimal downtime and safe rollback.

Schema Context

transactions(txn_id, created_at, status, amount, tenant_id)