Question

18) Which of the following is an example that would need to use an ETL process:

f. Moving data from the old system into a newly developed and deployed system
a. Entering a Sale Order in the transaction processing system
b. Entering a Car Rental in an ERP system
c. Merging sales data with advertising data and deploying the merged data into a business intelligence tool
d. 2 of the above are correct.

Answer 1

The example that requires an ETL process is c) merging sales data with advertising data and deploying the merged data into a business intelligence tool.

Step-by-step explanation:

The example that would need to use an ETL (Extract, Transform, Load) process is c) Merging sales data with advertising data and deploying the merged data into a business intelligence tool.

ETL is a process used in data integration to extract data from various sources, transform it into a suitable format, and load it into a target system.

In this example, merging sales data with advertising data involves extracting data from multiple sources, transforming it by combining and organizing the data, and loading it into a business intelligence tool for analysis and reporting.