MuleSoft Certified Integration Architect – Level 1 — Question 88
A Mule application is built to support a local transaction for a series of operations on a single database. The Mule application has a Scatter-Gather that participates in the local transaction.
What is the behavior of the Scatter-Gather when running within this local transaction?
Answer options
- A. Execution of each route within the Scatter-Gather occurs sequentially Any error that occurs inside the Scatter-Gather will result in a rollback of all the database operations
- B. Execution of all routes within the Scatter-Gather occurs in parallel Any error that occurs inside the Scatter-Gather will result in a rollback of all the database operations
- C. Execution of each route within the Scatter-Gather occurs sequentially Any error that occurs inside the Scatter-Gather will NOT result in a rollback of any of the database operations
- D. Execution of each route within the Scatter-Gather occurs in parallel Any error that occurs inside the Scatter-Gather will NOT result in a rollback of any of the database operations
Correct answer: A
Explanation
The correct answer is A because when a Scatter-Gather is involved in a local transaction, the execution of each route occurs sequentially, ensuring that if any error arises, all database operations are rolled back to maintain data integrity. The other options incorrectly describe the execution model or the rollback behavior of the operations within the Scatter-Gather.