Q1. Define the term OLAP. Illustrate the four various types of OLAP Servers from implementation view point? Describe in brief.
Q2. Describe the difference between dimensional data modeling and relational data modeling.
Q3. Describe the main steps in Extraction Transformation and Loading (or ETL) process.
Q4. Describe the different classes of users of warehouse systems. Explain why data-quality is significant in a warehouse?
Q5. Write detail notes on any three:
a) Data Accuracy versus Data Quality
b) Cyclicity of data
c) Drill down analysis
d) Snowflake schema