Loyola College M.Sc. Computer Science Nov 2012 Data Warehousing Question Paper PDF Download

LOYOLA COLLEGE (AUTONOMOUS), CHENNAI – 600 034

M.Sc. DEGREE EXAMINATION – COMPUTER SC.

THIRD SEMESTER – NOVEMBER 2012

CS 3812 – DATA WAREHOUSING

 

 

Date : 01/11/2012            Dept. No.                                        Max. : 100 Marks

Time : 9:00 – 12:00

 

 

Part A

Answer all the questions:                                                                                              10 x 2 = 20 Marks

 

  1. Identify the relationship between Data Warehouse and Data Mart.
  2. Specify the sources of Metadata.
  3. What are the changes expected in dimensional tables?
  4. List the characteristics of high quality data.
  5. Differentiate Dimensional modules from ER modules.
  6. What is surrogate key?
  7. Name any four key capabilities of OLAP.
  8. List any four criteria for evaluating data mining tools.
  9. Notify the advantage of Clustered Index.
  10. What is security policy?

 

Part B

Answer all the questions:                                                                                                5 x 8 = 40 Marks

 

  1. a) Compare Data Warehouse with ERP and Knowledge Management.

(Or )

  1. b) Elaborate the phases of Joint Application Development (JAD).

 

  1. a) Write about the consideration in building technical metadata.

(Or )

  1. b) Discuss & justify the influencing factors in selection of a DBMS.

 

  1. a) Compare the characteristics of dimensional table & fact table.

(Or)

  1. b) Stress the need for aggregates and describe the ways to construct aggregate fact

tables.

 

  1. a) Review OLAP architectural options.

(Or)

  1. b) Briefly describe the cluster detection technique.

 

  1. a) Compare the significance of performance enhancement techniques.

(Or)

  1. b) Discuss the principles of Indexing and explain Bit Mapped Index.

 

 

 

Part C

Answer any two questions:                                                                                           2 x 20 = 40 Marks

 

  1. a) List and explain the components of Data Warehouse. (10 Marks)

 

  1. b) Compare server hardware available for the Data Warehouse. (10 Marks)

 

  1. a) Depict the design of star schema and explain star schema keys. (10 Marks)

 

  1. b) With neat diagram, describe information delivery framework. (10 Marks)

 

  1. a) Describe the types of pilot projects and discuss their merits. (10 Marks)

 

  1. b) Explain how a genetic algorithm helps in increasing profit of the organization.

(10 Marks)

 

 

Go To Main page

 

 

Latest Govt Job & Exam Updates:

View Full List ...

© Copyright Entrance India - Engineering and Medical Entrance Exams in India | Website Maintained by Firewall Firm - IT Monteur