CompTIA Data+ (DA0-001) — Question 9

Which of the following is a process that is used during data integration to collect, blend, and load data?

Answer options

• A. MDM
• B. ETL
• C. OLTP
• D. BI

Correct answer: B

Explanation

ETL, which stands for Extract, Transform, Load, is the correct process as it specifically refers to the collection, blending, and loading of data from various sources. MDM (Master Data Management) focuses on maintaining a single, accurate view of business data, while OLTP (Online Transaction Processing) is related to transaction management. BI (Business Intelligence) involves analyzing data but does not directly handle the integration process.