Data Warehousing

What is NOT slowly changed dimension? You may answer multiple correct answers

• Address

• Body Mass Index

• Last Name

• Date of Birth

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

We can obtain patient age by determining the year difference between Today and DATEADM

• True

• False

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

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