Data Warehouse

What does ETL stand for in the context of data warehousing?

• Extract, Transfer, Load

• Extract, Transmit, Load

• Extract, Translate, Load

• Extract, Transform, Load

Data warehouse coined in

• 1991

• 1990

• 1987

• 1975

How many stages in data warehouse

• 4

• 5

• 6

• 3

Data warehouse also called as

• OLTP

• ETL

• OLAP

• None of these

Data warehouse concerned with

• Historical data

• Current data

• Analytical data

• None of these

It is related to ___

• Both b and c

• Process oriented

• Subject oriented

• None of these

What are the features of data warehouse

• Subject oriented

• Integrated

• Time variant

• All of the above

Data warehouse coined by

• Bjarne Stroustrup.

• Bill inmon

• James gosling

• None of these

Data warehouse mostly used for

• Data integration and data mining

• Data mining and data storage

• Reporting and data analysis

• Data cleaning and data storage

The main purpose of a data warehouse is to research different data

• True

• False