Multiple ChoiceHard 45s
Avoiding Dual-Write Problems
Why is dual-writing to two data stores directly from application code considered an anti-pattern?
Options
- 1It cannot be made atomic, so failures leave the two stores inconsistent with no reliable source of truth
- 2It is inherently slower than writing to a single store because two network round trips are required
- 3It always violates the SQL standard, which forbids more than one store being written per statement
- 4It prevents the use of transactions in either store, so no ACID guarantees are available at all
Think you can answer under pressure?
Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.