STUPIDSID
Solve any one question from Q.1(a,b) & Q.2(a,b)
1(a)
What is OLAP? Explain the guidelines for implementation of OLAP.
6 M
1(b)
Define Business Intelligence. Explain the role of data warehouse in Business Inetelligence.
4 M
2(a)
What are facts? Explain additive, semi-additive and non-additive facts with the help of example.
6 M
2(b)
Differentiate between OLAP and OLTP.
4 M
Solve any one question from Q.3(a,b) & Q.4(a,b)
3(a)
Explain different types of schema used for data warehouse design.
4 M
3(b)
Explain components of ETL architecture with the help of neat diagram.
6 M
4(a)
Explain data mart in detail.
4 M
4(b)
Write short note on: (Each 3 Marks) ,br> i) Sowly Changing Dimensions (SCD)
ii) Conformed Dimensions
ii) Conformed Dimensions
6 M
Solve any one question from Q.5(a,b) & Q.6(a,b)
5(a)
What are the various types of Reports? Explain Ad-hoc reporting in detail.
8 M
5(b)
What is data aggregation? Explain use of data aggregation.
8 M
6(a)
Explain the importance of security while creating Business Intelligence reports. Explain different types of securities in reporting.
8 M
6(b)
What is materialized view and Snapshot materialized view? Explain with proper example.
8 M
Solve any one question from Q.7(a,b) & Q.8(a,b)
7(a)
Explain cluster analysis with real world example. Also list out its applications.
8 M
7(b)
Compare and contrast In-DB and In-memory analytics.
8 M
8(a)
What is time-series analysis? Explain the ways to identify the patterns in time-series data.
8 M
8(b)
Explain hierarchical clustering algorithm along with different methods to calculate the distance between clusters.
8 M
Solve any one question from Q.9(a,b) & Q.10(a,b,c,d)
9(a)
Explain with neat diagram the architecture of Business Intelligence on cloud.
10 M
9(b)
Explain the components of Teradata with the help of diagram.
8 M
Write short notes any three question from Q.10(a, b, c, d)
10(a)
Map-Reduce
6 M
10(b)
HDFS
6 M
10(c)
PIG
6 M
10(d)
HIVE
6 M
More question papers from Business Intelligence