MuleSoft Certified Integration Architect – Level 1 — Question 29

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. API-led connectivity
• B. Batch-triggered ETL
• C. Event-driven architecture
• D. Microservice architecture

Correct answer: B

Explanation

The correct answer is B, Batch-triggered ETL, as it is designed to handle large volumes of data efficiently, allowing for the processing of daily snapshots in bulk. API-led connectivity (A) is more suitable for real-time integrations, which is not needed here. Event-driven architecture (C) is also not appropriate since it focuses on real-time event processing rather than batch data transfers. Microservice architecture (D) can provide flexibility but does not specifically address the batch processing requirement for high-volume data transfers.