Data Warehouse :: Introduction

Why was data warehousing proposed?

• To keep track of transactional data

• To keep summarized historical information

• To manage data from heterogeneous sources

• To produce management reports

What is a data warehouse?

• Is a relational database that is designed for query and analysis
• Is a non-relational database that is designed for query and analysis

The warehouse is organised around the _______ of the enterprise

• major operational applications

• priority strategic areas

• main business subjects

• selected data marts

In data warehousing, what is time-variant data?

• Data in the warehouse is only accurate and valid at some point in time or over time interval

• Data in the warehouse is always accurate and valid

• Data in the warehouse is only accurate sometimes

• Data in the warehouse is not accurate

Who are the two important persons in data warehousing?

• Kimball & Inmon

• Kelly & Kimball

• Tim-Berners Lee & Kimball

• Inmon & Tim-Berners Lee

What is a benefit of a data warehouse?

• Data flexibility

• Reduced implementation cost

• Competitive advantage

• Decentralized data ownership

Which type of SCD (Slowly changing dimensions) do we preserve history of data?

• Type 1

• Type 2

• Type 3

• None of the above

What is a Data Mart?

• A data mart is a subgroup of the data warehouse
• A data mart is another type of data warehouse
• A data mart is not actually related to data warehouses
• None of these

Metadata is data about data

• True
• False

Is the data in a data warehouse generally updated in real-time?

• Yes

• No