Q1. Data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of the data to support of management’s decision-making process. Comment on it.
Q2. Explain how is data structured in the Data Warehouse? Describe?
Q3. What do you mean by Granularity? Illustrate the benefits associated to a Data Warehouse?
Q4. Write brief note on:
a) Methods to make feedback loop harmonious.
b) Snapshots in the Data Warehouse.
Q5. Write down in detail regarding the three data models used in the Data Warehouse.
Q6. Describe the Star Schema and snowflake schema with the help of illustrations.
Q7. Describe the technological needs of the Data Warehouse.