MuleSoft Certified Integration Architect – Level 1 — Question 42
A Mule application is being designed to receive nightly a CSV file containing millions of records from an external vendor over SFTP. The records from the file need to be validated, transformed, and then written to a database. Records can be inserted into the database in any order.
In this use case, what combination of Mule components provides the most effective and performant way to write these records to the database?
Answer options
- A. Use a Batch Job scope to bulk insert records into the database
- B. Use a Scatter-Gather to bulk insert records into the database
- C. Use a Parallel For Each scope to insert records one by one into the database
- D. Use a DataWeave map operation and an Async scope to insert records one by one into the database
Correct answer: A
Explanation
The correct answer is A because using a Batch Job scope allows for efficient bulk processing of records, which is ideal for handling large volumes of data like millions of records. Options B, C, and D are less effective as they either introduce unnecessary complexity or do not optimize the insertion process for large datasets.