mid_II_Dw - data warehouse architecture. [8] Q.2. Give...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Birla Institute of Technology & Science, Pilani Work-Integrated Learning Programmes Division First Semester 2009-2010 Mid-Semester Test (EC-1 Regular) Course No. : SS ZG515 Course Title : Data Warehousing Nature of Exam : Closed Book Weightage : 40% Duration : 2 Hours Date of Exam : 29/08/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 are dependent and independent data marts? Describe their roles in the overall
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: data warehouse architecture. [8] Q.2. Give situations under which there is a need to distort the classical star schema. Some DW access tools require classical star schema. How can we use such tools when the classical star schema is distorted? [8] Q.3. What is a coverage fact table? What purpose it serves in a grocery store sales data mart? Give a suitable schema of coverage fact table and discuss its granularity. [8] Q.4. What are the advantages and disadvantages of having finest granularity data in the data warehouse and data marts? [8] Q.5. What are the features and functionalities that a user should expect from an OLAP tool? Give a brief description. [8] ********* No. of Pages = 1 No. of Questions = 5...
View Full 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.

Ask a homework question - tutors are online