comp_IIi_dw - Birla Institute of Technology & Science,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Birla Institute of Technology & Science, Pilani Distance Learning Programmes Division Second Semester 2008-2009 Comprehensive Examination (EC-2 Regular) Course No. : SS ZG515 Course Title : DATA WAREHOUSING Nature of Exam : Open Book Weightage : 60% Duration : 3 Hours Date of Exam : 04/04/2009 (AN) Note: 1. Please follow all the Instructions to Candidates given on the cover page of the answer book. 2. All parts of a question should be answered consecutively. Each answer should start from a fresh page. 3. Mobile phones and computers of any kind should not be used inside the examination hall. 4. Use of any unfair means will result in severe disciplinary action. Q.1 What new operators are being added to SQL to make it more suitable for OLAP? Give details about these operators. [10] Q.2 Compare and contrast aggregates and indexes. Also compare and contrast aggregates and data marts. [10] Q.3 What role views play in dimensional modeling? Give example situations where one would use views. [10] Q.4 A Bank offers 25 different types of services. The bank has 250 branches spread over 50 states. On any given day it is observed that only 15% of the account holders utilize the bank services. On an average each branch has 30,000 accounts. The bank is currently holding data for 900 days (monthly aggregates are required). (a)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/05/2012 for the course CSE ss zg513 taught by Professor Raj during the Spring '11 term at Birla Institute of Technology & Science, Pilani - Hyderabad.

Page1 / 2

comp_IIi_dw - Birla Institute of Technology & Science,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online