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 do we apply snowflake schema?

• Aggregation

• Normalization

• Generalization

• Transformation

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

What is CORRECT about dimensional modeling?

• It is designed to support query

• It is designed to support storage

• It is entity-relationship modeling

• It does not need normalization

Data warehouse is subject-oriented

• True

• False

What is NOT aggregation function?

• Median

• Count

• Distinct

• Sum