MuleSoft Certified Integration Architect – Level 1 — Question 78

A Mule application is synchronizing customer data between two different database systems.

What is the main benefit of using eXtended Architecture (XA) transactions over local transactions to synchronize these two different database systems?

Answer options

• A. An XA transaction synchronizes the database systems with the least amount of Mule configuration or coding
• B. An XA transaction handles the largest number of requests in the shortest time
• C. An XA transaction automatically rolls back operations against both database systems if any operation falls
• D. An XA transaction writes to both database systems as fast as possible

Correct answer: C

Explanation

The correct answer is C because XA transactions ensure that if an operation on one database fails, all operations across both databases are rolled back, maintaining data consistency. Options A, B, and D do not capture this critical rollback capability, which is essential for maintaining integrity in distributed transactions.