Preparing your PDF
Loading PDF viewer...
Introduction to Data Warehousing
Semester
Subject
💡 Jump to Important Questions ↓
Important Questions
Important Questions
Introduction to Data Warehousing
Asked in 2081Long Question10 Marks
1.
When do we prefer trim mean for statistical description of data? Justify with an example. Describe about multi-dimensional data model and conceptual modeling of data warehouse. [10]
Asked in 2080Long Question10 Marks
2.
Why the concept of data mart is important? Discuss different data warehouse schema with examples. [10]
Asked in 2079Short Question5 Marks
3.
Write down short notes on: a. Data Mart b. Market Basket Analysis [5]
Asked in 2079Short Question5 Marks
4.
Why data normalization is important in data mining? Explain min-max and Z-score normalization approach. [5]
Asked in 2079Long Question10 Marks
5.
Why OLAP operations are used? Discuss various OLAP operation with suitable example of each. [10]
Asked in 2078Short Question5 Marks
6.
Differentiate between star schema and snow flake schema. List any two methods for data normalization. [5]
Asked in 2078Long Question10 Marks
7.
Write down any one advantage and disadvantage of MOLAP over ROLAP. Define signed network and how do you check whether it is balanced or not? How beam search reduces the space complexity? Illustrate with an example. [10]
Asked in 2076Short Question5 Marks
8.
What does data warehouse tuning mean? Describe the parameters. [5]
Asked in 2076Short Question5 Marks
9.
Compare the OLAP servers, ROLAP, MOLAP and HOLAP. [5]
Asked in 2076Short Question5 Marks
10.
How multidimensional data model helps in retrieving information? Explain with suitable example. [5]
Asked in 2076Short Question5 Marks
11.
Explain the four characteristics of data warehouse. [5]
Asked in 2075Short Question5 Marks
12.
How different schema are used to model data warehouse? Explain. [5]