CS614 Current Midterm Paper Fall 2013 shared by jia khan File 5

by on December 24, 2013 at 6:25pm

My Today Paper

Q.NO 1:

purpose of aggregate awarneness.

Solution:

Aggregate awareness allows using pre-built summary tables by some
front-end tools.

the environment is smart enough to develop or compute higher level aggregates using lower level or more detailed aggregates.(ye statement mcq mn b thi)

Q.NO 2:

Two steps of BSN method:

Solution:

 Steps 1: Create Keys

 Step 2: Sort Data

 Step 3: Merge

Q.NO 3:

" No single key is sufficient to catch all matching records" this is the limitation of BSN .what can we do to avoid this limitation?

Solution:

Page NO 177

Q.NO 4:

"performance increase with the use of disk space" which factor lead to relation between performance and disk space?

Solution:

I think its is De Normalization because denormalization increase performance(plz check)

Q.No 5

Identify types of transformation

"a data element form the source system results in several columns in the DW"

second yad ni

Solution:

1st statement is one to many 

2nd was many to many

Q.NO 6:

Roll up and Drill down with example

Solution:

Rollup: summarize data
ƒ e.g., given sales data, summarize sales for last year by product category
and region

ƒ Drill down: get more details
ƒ e.g., given summarized sales as above, find breakup of sales by city within
each region, or within Sindh