# IT6702 Question Bank Data Warehousing and Data Mining Regulation 2013 Anna University

## IT6702 Question Bank Data Warehousing and Data Mining

IT6702 Question Bank Data Warehousing and Data Mining Regulation 2013 Anna University free download. Data Warehousing and Data Mining IT6702 Question Bank pdf free download.

### Sample IT6702 Question Bank Data Warehousing and Data Mining

1. Explain in detail about the reporting and query tools. (May/June 2014)
2. Describe in detail about COGNOS IMPROMTU. (May/June 2014)
3. Explain the categorization of OLAP tools with necessary diagrams.(May/June
2014)
4. i) List and explain the OLAP operation in multidimensional data model.
(Nov/Dec 2014) IT6702 Question Bank Data Warehousing and Data Mining
ii) Differentiate between OLTP and OLAP. (Nov/Dec 2014)
5. i)List and discuss the features of Cognos Impromptu. (Nov/Dec 2012)
ii)List and discuss the basic features data provided by reporting and query tools
used for business analysis. (Apr/May 2011)
6. i) What is a Multidimensional data model? Explain star schema with an example.
(May/June 2014) IT6702 Question Bank Data Warehousing and Data Mining
ii) Write the difference between multi-dimensional OLAP (MOLAP) and Multirelational
OLAP (ROLAP). (May/June 2014, Nov/Dec 2012)
7. Explain the following: (May/June 2012)
i) Different schemas for multidimensional databases.

16. List out OLAP operations in multidimensional data model. (May/June 2009)
 Roll-up – performs aggregation on a data cube
 Drill-down – is the reverse operation of roll-up.
 Slice and dice – Slice operation selects one particular dimension from a IT6702 Question Bank Data Warehousing and Data Mining
given cube and provides a new sub-cube. Dice selects two or more
dimensions from a given cube and provides a new sub-cube.
 Pivot (or) rotate – The pivot operation is also known as rotation. It rotates
the data axes in view in order to provide an alternative presentation of data.
17. Mention the functions of OLAP servers in the data warehousing architecture.
(Nov/Dec 2010)
The OLAP server performs multidimensional queries of data and stores the
results in its multidimensional storage. It speeds the analysis of fact tables into IT6702 Question Bank Data Warehousing and Data Mining
cubes, stores the cubes until needed, and then quickly returns the data to clients.

 Subject Name Data Warehousing and Data Mining Subject Code IT6702 Regulation 2013 File PDF