What Is Extraction, Transformation, and Loading

question 95

Multiple Choice

What is extraction, transformation, and loading?

• A) It is a process of entering data, tracking data, and loading it into a database
• B) It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse
• C) It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube
• D) It is a process that is performed at the beginning of the data mining model

---

Definitions:

Assumptions

Beliefs or statements taken for granted without proof, often serving as a foundation for further reasoning or arguments.

Phenomena

Observable events or occurrences that can be investigated scientifically to understand their underlying principles or mechanisms.

Observing And Measuring

The process of collecting data about phenomena or behaviors through direct observation and using tools to quantify the observations.

Empirically Tested

Evaluated or tested through observation or experiment rather than theory or pure logic.