MULESOFT-INTEGRATION-ARCHITECT-I practice question 3 of 10
A Mule application is being designed to do the following: Step 1: Read a SalesOrder message from a JMS queue, where each SalesOrder consists of a…
Full set: 273 questionsThe scenario requires ensuring data consistency across three different transactional resources: a JMS queue and two separate RDBMS instances. This is a classic use case for a distributed transaction. An XA (eXtended Architecture) transaction coordinates multiple resources in a single, atomic unit of work. By wrapping the JMS read and both database inserts within the same XA transaction, the system guarantees that either all operations succeed (commit) or all are rolled back if any single operation fails. This prevents message loss and ensures the two databases remain consistent with each other.
A. A single DB transaction cannot span two different RDBMS instances. Also, if the DB insert fails, the JMS message might be lost if acknowledged separately.
B. Using separate DB transactions breaks atomicity. If the first DB insert succeeds but the second fails, the data becomes inconsistent across the two RDBMSs.
D. Acknowledging the JMS message before the database transactions means the message is permanently removed from the queue. If the subsequent XA transaction fails, the message is lost.
1. MuleSoft Documentation, "Transactions in Mule Applications". This document explains that "XA transactions are transactions that can span across multiple transactional resources". It details how to configure a flow with a JMS listener and multiple database connectors to participate in a single XA transaction to ensure data integrity. (See section on "XA Transactions").
2. MuleSoft Documentation, "JMS Connector - Mule 4 > Transactions". This page states: "To have a JMS transaction and a database transaction in the same transaction, you must use an XA transaction". This directly supports the need for XA in this scenario.
Keep practicing
Take the free MULESOFT-INTEGRATION-ARCHITECT-I practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MULESOFT-INTEGRATION-ARCHITECT-I practice questions
- Question 1An organization heeds to procure an enterprise software system to increase cross-selling …
- Question 4An organization has various integrations implemented as Mule applications. Some of these …
- Question 5An organization is sizing an Anypoint VPC to extend their internal network to Cloudhub. F…
- Question 6A REST API is being designed to implement a Mule application. What standard interface def…
- Question 7To implement predictive maintenance on its machinery equipment, ACME Tractors has install…
- Question 8A retailer is designing a data exchange interface to be used by its suppliers. The interf…
