What is the main benefit of using XA transaction over local transactions to synchronize these two database system?

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

What is the main benefit of using XA transaction over local transactions to synchronize these two database system?

A. Reduce latency

B. Increase throughput

C. Simplifies communincation

D. Ensure consistency

View Answer

Answer: D

Explanation:

* XA transaction add tremendous latency so "Reduce Latency" is incorrect option XA transactions define "All or No" commit protocol.

* Each local XA resource manager supports the A.C.I.D properties (Atomicity, Consistency, Isolation, and Durability).

So correct choice is "Ensure consistency"

Reference: https://docs.mulesoft.com/mule-runtime/4.3/xa-transactions