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)