Chapter 2, Problem 1MCQ

To determine

Identify the appropriate answer for the given statement from the given choices.

Answer to Problem 1MCQ

Option c. mastering the data can also be described via the ETL process. The ETL process stands for extract, transform, and load data.

Explanation of Solution

ETL process:

ETL stands for extraction, transformation and loading of data. The process of ETL starts with identification of the required data and ends with the loading of the clean data in the appropriate format which will be used for analysis.

Justification for correct and incorrect answer:

a.

Extract, total, and load data: This is not the correct choice as the ETL process stands for extraction, transformation and loading of data.

b.

Enter, transform, and load data: This option is an incorrect option because the ETL process stands for extraction, transformation and loading of data and not for enter, transform, and load data.

c.

Extract, transform, and load data: This option is correct because the ETL process stands for extraction, transformation and loading of data.

d.

Enter, total, and load data: This is an incorrect option because it is not the correct extension of ETL process. The ETL process stands for extraction, transformation and loading of data.