Data Warehousing

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 are used in Multi-dimensional modeling?

• Foreign key

• Fact Table

• Dimensional Table

• Surrogate key

Which one come first to build data warehouse

• Data Cleansing

• Business questions

• Data Acquisition

• Data Profiling

Why aggregate is used in dimensional model of data warehouse?

• To store data in one operational system

• To retrieve data from an operational system

• To combine data from heterogeneous sources

• To take the dimension and change its granularity

Why do we apply snowflake schema?

• Aggregation

• Normalization

• Generalization

• Transformation

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

Data warehouse is subject-oriented

• True

• False

What is NOT aggregation function?

• Median

• Count

• Distinct

• Sum

What is data to describe data in data warehouse?

• Relational data

• Operational data

• Informational data

• Metadata