CS614 Fall 2011 Final Term Feb 2012 – VU Current Paper – 08 Feb 2012

Total 53 questions nd paper total marks 80. 40 mcqs, 5 ques 2 marks, 5 ques 3 marks and 3 ques 5 marks.

1. Do you think it will create the problem of non-standardized attributes, if one source uses 0/1 and second source uses 1/0 to store male/female attribute

respectively? Give a reason to support your answer. 2 marks
2. How the three parallel tracks capture the user requirements in the Kimball s data
warehouse life cycle Road Map / three parallel techniques. 5 marks
3. Transient and persistence cookies also limitations of those cookies. 5 marks
4.data profiling nd purposes of data profiling. 3 marks
5.how the queries are differ for OLTP and DWH environment? Or diff b/w OLTP nd DWH? 2 marks
6.Write down the steps which are performed in clustering process. 3 marks
7. Give name of activities to be performed in planning and design phase as discussed in agri-DWH case study. 3 marks
8. problem in Partition Skew based Hash join. 3 marks
9. total quality management. How total quality management technique is differ nd better from old management techniques. 2 marks
10. b-tree indexing limitations. 2 marks
11. roll out and maintainance phase of agri DWH. 3 marks
12. Data Transformation Services (DTS) provide a set of tools, Packages, tasks and connections that lets you extract, transform, and consolidate data from disparate sources into single or multipledestinations supported by DTS connectivity 5 marks

i) How Business validation rule implemented in DTS? 5
ii) Clickstream? how it is useful in a web dwh environment. 3
iii) Data profiling is a process of gathering information about columns, what are the purpose that it must fulfill? Describe briefly 5
iv) Why a Pilot project strategy Is highly recommended in dwh construction. 5
v) Need for indexing with reference to i/o speed 3
vi) Analytic application development 5
vii) Two extremes for tech. arch. Design, which one is better 2
viii) Which script language is used to perform complex transformation in dts package 2
ix) What types of operations are performed by MS DTS. 3
x) Name of the pest scouting org and the year of its starting. Answer DPWQCP 1984, 2 marks