MCIA-LEVEL-1 practice question 22 of 30

An organization is designing an integration solution to replicate financial transaction data from a legacy system into a data warehouse (DWH). The…

Full set: 244 questions
An organization is designing an integration solution to replicate financial transaction data from a legacy system into a data warehouse (DWH). The DWH must contain a daily snapshot of financial transactions, to be delivered as a CSV file. Daily transaction volume exceeds tens of millions of records, with significant spikes in volume during popular shopping periods. What is the most appropriate integration style for an integration solution that meets the organization's current requirements?
Answer options
A: Event-driven architecture
B: Microservice architecture
C: API-led connectivity
D: Batch-triggered ETL Correct answer
Correct Answer:
D. Batch-triggered ETL
Explanation

Correct answer is Batch-triggered ETL Within a Mule application, batch processing provides a construct for asynchronously processing larger-than-memory data sets that are split into individual records. Batch jobs allow for the description of a reliable process that automatically splits up source data and stores it into persistent queues, which makes it possible to process large data sets while providing reliability. In the event that the application is redeployed or Mule crashes, the job execution is able to resume at the point it stopped.

Scroll to Top