SQL Practice Logo

SQLPractice Online

Level 9 - DistinguishedOptimization Questionsm4 replication recovery failover

Optimization: Commit Mode for Payment Writes

Choose better durability mode for payment ledger writes. Query A: Use async commit for all payment_ledger inserts to maximize throughput. Query B: Use synchronous commit (or quorum-ack policy) for payment_ledger writes, and async for non-critical audit stream.