Code: AT19                                                                              Subject: DATA WAREHOUSING

Time: 3 Hours                                                                                             AND DATA MINING

Max. Marks: 100

NOTE: There are 9 Questions in all.

· Question 1 is compulsory and carries 20 marks. Answer to Q. 1. must be written in the space provided for it in the answer book supplied and nowhere else.

· Out of the remaining EIGHT Questions answer any FIVE Questions. Each question carries 16 marks.

· Any required data not explicitly given, may be suitably assumed and stated.

Q.1       Choose the correct or best alternative in the following:                                         (2x10)

       a.      The two kinds of data at the heart of an architected environment  are

(A)  Primitive data and secondary data.

(B)  Derived data and primary data.

(C)  Primitive data and derived data.

(D)  Primitive data and primary data.

       b.     Partitioning of data refers to

(A)  Breakup of data

(B)  Separating physical units.

(C)  Separating independent units.

(D)  Break up of data into separate physical units.

       c.      The three level of data modeling are

(A)  Multi level, Mid level, Low level.

(B)  Low  level, Physical level, Multi level.

(C)  Physical level, Open level, Low level.

(D)  High level, Mid level, Low level.

       d.     Metadata is 

(A)  Data out of main data.

(B)  Data about data.

(C)  Separating primary & secondary data.

(D)  Partitioning of data.

       e.      Data is cleansed as it passes from

(A)  Operational environment to the data warehouse environment.

(B)  Open environment to closed environment.

(C)  Closed environment to the data warehouse environment.

(D)  High level environment to low level environment.

       f.      The primary issue of granularity  is

(A)  Level of granularity is too high.

(B)  Level of granularity is too low.

(C)  Level of granularity is at right level.

(D)  Level of granularity is at medium level.

       g.      EIS means

(A)  External Information System.

(B)  External Internal System.

(C)  Executive Internal System.

(D)  Executive Information System.

       h.      Event mapping technique used in EIS processing is depicted by

(A)  Two step trend line.

(B)  Simple trend line.

(C)  Three step trend line

(D)  Four step trend line.

       i.       The beginning point for the migration plan is

(A)  Corporate Data Model.
(B)  External Data Model.

(C)  Internal Data Model.

(D)  Mata Data Model.

       j.      Which one of the following is not an OLAP operation?

(A)  Drill-up.                                                                                                             

(B)  Drill-down.

(C)  Drill-across.

(D)  Drill-through.

Answer any FIVE Questions out of EIGHT Questions.

Each question carries 16 marks.

Q.2     a.   Briefly explain the role of DSS in data warehousing.                                            (8)

             b.   What are the major reasons for lack of Data Credibility?                                     (8)

Q.3     a.   What are the differences between primitive and derived data?                            (8)

             b.   Elaborate the major operating components, which are regularly monitored in data warehouse environment.                                                             (8)

Q.4     a. Briefly explain how Exploration and Data Mining is useful in data warehouse.                        (8)

             b.   What do you understand by partitioning of data? How it is done and what are its benefits?                (8)

Q.5     a.   Briefly explain Mata data? List the items the Mata Data store tracks.                   (8)

             b.   What are the different levels of data modeling? Briefly explain midlevel modeling.                  (8)

Q.6     a.   What is EIS? List some of the typical uses of EIS.                                              (8)

             b.   Briefly explain drill-up and drill–down Analysis                                                   (8)

Q.7     a.   Explain with the help of block schematic, the role of Mata data in managing external data.                 (8)

             b.   Briefly explain how External Data is achieved and also compare Internal data to External data.                      (8)

Q.8     a.   How the Migration  Plan is implemented in Corporate Data Model?. Explain it with the help of Block diagram.                                                (8)

             b.   Briefly explain Methodology and Migration .                                                      (8)

Q.9          Write short note on any four:-                                                                         (4x4)

                   (i)   Event Mapping.

                   (ii)  Data Cleaning.

                   (iii) Data Mining.

                   (iv) Feedback loop in data architect.

                   (v)  Data Mining and Machine Learning.