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:

Categories

Classifications or divisions of items, concepts, or entities based on shared characteristics or attributes.

Technology

The application of scientific knowledge for practical purposes, especially in industry, where it encompasses processes, designs, and tools.

Interest Groups

Organizations formed to influence public policy and decision-making in favor of specific interests or causes.

Methods

Systematic ways or approaches used to accomplish a task, conduct research, or solve a problem.