Q1. Distinguish between the primitive and derived data.
Q2. Describe the system development life cycle of a data warehouse. What factors must be considered while designing a data warehouse.
Q3. Describe the snowflake schema with the help of illustrations.
Q4. What do you mean by Data warehouse? Describe the characteristics of the data warehouse.
Q5. Describe why data warehouse metadata is significant.
Q6. Describe the differences between the DBMS and Data warehouses.
Q7. List all the strengths and weaknesses of multidimensional DBMS data marts?
Q8. Illustrate the difference between the local and global warehouse.
Q9. What do you meant by Drill Down analysis? Describe its merits to the manager.
Q10. What are the issues related to the use and storage of external data in data warehouse? Describe how such data is stored in the Data warehouse.
Q11. Describe the list of technological challenges which comprises in the data migration methodology.
Q12. Write brief notes on any three of the given terms:
a) The spider web
b) Auditing of data warehouse
c) Event mapping
d) Metadata management