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:

Standard Direct Materials Costs

The budgeted or standard cost of the raw materials required to produce a unit of product.

Standard Price

A predetermined cost that companies use to budget and evaluate the performance of actual costs.

Standard Quantity

The established amount of materials or inputs expected to be used in the production of a good or service.

Total Manufacturing Cost Variance

The difference between total standard costs and total actual costs for the units produced.