Data warehouse basics

What does the acronym ETL stands for?

• Explain,Transfer and Lead

• Extract,Transform and Load

• Extract,Transfer and Load

• Effect,Transfer and Load

What is the system of data warehousing mostly used for?

• Data integration and Data Mining

• Data Mining and Data Storage

• Reporting and Data Analysis

• Data Cleaning and Data Storage

What does the typical Extract,Transform,Load(ETL) based data warehouse use to house its key functions?

• Staging

• Access Layers

• Data Integration

• All of the above

What is the combination of facts and dimensions sometimes called?

• Physical Schema

• Star Schema

• Dimension Model

• Denormalizing Modelling

What does the access layer help users to do?

• Store data

• Analyse Data

• Clean Data

• Retrieve Data

What type of data formats do conventional database systems use?

• Highly Denormalized

• Highly Normalised

• A and B

• None of the Above

What is computing in data warehouse s often referred to as?

• OLAP

• OLAT

• OLTP

• OLTA

When does data staging occur in data warehousing?

• A periodic process reads data from sources

• A periodic process stores data got from sources

• A periodic process mines data from sources

• None of the above

Which small logical units do data warehouses hold large amounts of information?

• Data Storage

• Data Marts

• Access Layers

• Data Miners

What is reconciled data?

• Data stored in one operational system

• Data stored in the various operational systems available in the organisation

• Current data intended to be single source for allowing decision support systems

• Data that has been selected for end user applications