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

Recognize the tools available for inserting and editing various chart elements in Excel.

Understand how to use Excel to project future data trends.

Grasp the concept and application of conditional formatting and calculations.

Learn to use Excel for date and time manipulation.

---

Definitions:

Money Multiplier

The ratio of the amount of deposits created by banks to the amount of the central bank's monetary base that has been injected into the economy.

100-percent-reserve Banking

A banking system in which banks keep the full amount of their depositors' funds in reserve, meaning they do not loan out any of the deposits but instead hold 100% of deposited money.

Money Supply

The total amount of currency and monetary assets within an economy at a specific time.

Reserve Requirements

Regulations set by central banks determining the minimum amount of reserves that banks must hold against deposits, used to control the money supply.