Level 10 - MasterScenario-Based Questionsm1 end to end data architecture
Scenario: CDC vs Batch for Revenue Publishing
Revenue dashboard must refresh every 10 minutes while finance requires exact day-end reconciliation. Choose CDC or batch (or hybrid) and explain architecture with one rollback path.
Schema Context
payments(payment_id, order_id, amount, status, updated_at), revenue_snapshot(snapshot_ts, total_revenue)