MuleSoft Exam MCIA-Level-1 Topic 8 Question 21 Discussion

Actual exam question for MuleSoft's MCIA-Level-1 exam

Question #: 21
Topic #: 8

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 header and a list of SalesOrderLineltems.

Step 2: Insert the SalesOrder header and each SalesOrderLineltem into different tables in an RDBMS.

Step 3: Insert the SalesOrder header and the sum of the prices of all its SalesOrderLineltems into a table In a different RDBMS.

No SalesOrder message can be lost and the consistency of all SalesOrder-related information in both RDBMSs must be ensured at all times.

What design choice (including choice of transactions) and order of steps addresses these requirements?

ARead the JMS message (NOT in an XA transaction)
2) Perform BOTH DB inserts in ONE DB transaction
3) Acknowledge the JMS message

BRead the JMS message (NOT in an XA transaction)
2) Perform EACH DB insert in a SEPARATE DB transaction
3) Acknowledge the JMS message

CRead the JMS message in an XA transaction
2) In the SAME XA transaction, perform BOTH DB inserts but do NOT acknowledge the JMS message

DRead and acknowledge the JMS message (NOT in an XA transaction)
2) In a NEW XA transaction, perform BOTH DB inserts

Show Suggested Answer

Suggested Answer: A

by Clorinda at May 08, 2022, 04:24 PM

Limited Time Offer

25%

Off

Get Premium MCIA-Level-1 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Tripti

4 years ago

Why not C? as XA transaction will not loss the messages while processing, If fails some point of time while insertion at RDBMS ,It will rolledback and keep it somewhere and process in next time.

upvoted 1 times

...