Blog: CS614 Finalterm Paper 2013 File 3 Shared by Moaaz

CS614 – Final Term Paper (25 Feb 2013)

By Muhammad Moaaz Siddiq



About 23-25 Mcqs from My File ---



Subjective Questions are following (2 Questions I forgot)



Question No.41 (2 Marks)

Why analytic phase is called fun part in project designing?



Question No.42 (2 Marks)

Define Forward proxy?  



Question No.43 (2 Marks)

First two phases of kimball DWH process name them  



Question No.44 (2 Marks)

Define Rang Partition?  



Question No.45 (3 Marks)

A student wanted to visit and understand the data warehouse implementation strategies adopted in that organization has refused to allow. What may be the carrier of this refusal?



Question No.46 (3 Marks)

Data profiling is a process of gathering information about columns, what are the purpose that it must fulfill? 3Marks



Question No.47 (3 Marks)

Following statement is correct or incorrect? If incorrect then justify your answer   3Marks

Round-robin spreads data evenly across the partitions and always facilitates partition elimination.



Question No.49 (5 Marks)

What operations are provided by MS DTS?



Question No.50 (5 Marks)

Two customers want loan from bank and what will be the most suitable according to situation?  



Question No.52 (5 Marks)

Agri-DWH Conclusions & lessons learnt?