Advanced
Database Management Systems
Q90 / 100
What is the Saga pattern in distributed transactions?
Correct! Well done.
Incorrect.
The correct answer is B) A pattern breaking a distributed transaction into a sequence of local transactions with compensating transactions for rollback, avoiding 2PC across services
B
Correct Answer
A pattern breaking a distributed transaction into a sequence of local transactions with compensating transactions for rollback, avoiding 2PC across services
Explanation
The Saga pattern (choreography or orchestration) handles distributed transactions without 2PC. Each step has a compensating transaction for undo. Used in microservices where ACID across services is impractical.
Progress
90/100