SQL Practice Logo

SQLPractice Online

Level 10 - MasterScenario-Based Questionsm2 reliability ha dr multi region

Scenario: Active-Active Payment Writes

Design write strategy for active-active multi-region payment API where duplicate charges are unacceptable and regional failover must be automatic.

Schema Context

payment_commands(command_id, idempotency_key, tenant_id, amount, created_at), payment_ledger(entry_id, command_id, status)