MuleSoft Certified Integration Architect – Level 1 — Question 67

A Mule application currently writes to two separate SQL Server database instances across the internet using a single XA transaction. It is proposed to split this one transaction into two separate non-XA transactions with no other changes to the Mule application.
What non-functional requirement can be expected to be negatively affected when implementing this change?

Answer options

• A. Throughput
• B. Availability
• C. Response time
• D. Consistency

Correct answer: D

Explanation

The correct answer is D, as splitting the transaction into non-XA transactions may lead to potential inconsistencies between the two databases, especially if one transaction succeeds while the other fails. The other options, such as Throughput, Availability, and Response time, may not be significantly affected by this change, as they relate more to system performance rather than transactional integrity.