Enterprise Data Management

The term Data Warehouse was coined by Bill Inmon in 1990, which

he defined in the following way:

• "A warehouse is a subject-oriented, integrated, stable and volatile collection of data in support of management's decision making process".

• "A warehouse is a subject-oriented,integrated, time-variant and non-volatile collection of data in support of management's decision making process".

• Both A and B

• None of above

Definition of Subject Oriented Data: Data that gives information about a particular subject

instead of about a company's ongoing operations.

• True

• False

Definition of Integrated Data: Data that is gathered into the data warehouse from a variety of sources and merged into a coherent whole.

• True

• False

Which one is correct for data warehousing?

• It can be updated by end users

• It can solve all business questions

• It is designed for focus subject areas

• It contains only current data

Which one come first to build data warehouse

• Data Cleansing

• Business questions

• Data Acquisition

• Data Profiling

Why do we apply snowflake schema?

• Aggregation

• Normalization

• Generalization

• Transformation

When customer change address, we can overwrite the existing record.

• True

• False

What is importance of data profiling to data warehousing? You may answer more than one answer

• It helps to aggregate data

• It helps to understand data

• It helps to detect abnormality in data

• It helps to generate sample data

What is metadata in data warehousing? You may answer more than one

• Business definition

• Data dictionary

• BI report

• Measures

What is CORRECT about data warehouse? You may answer more than one

• It makes use of historical data to answer business questions

• It reveals insight from data

• It supports roll-up and drill-down to explore data

• Its design is the same as database