Skip to main content

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


Comments

Popular posts from this blog

CS614 Quiz No.4 Shared by Princess (solved), Spring 2014

  “What means What”. The phrase refers to: Select correct option:  Meta data  External data Transformed data Internal representations Question # 2 of 10 Which of the following is NOT one of the activities of “Maintenance and Growth” phase in Kimball’s DWH development approach? Select correct option: Education Technical Education Program Support  Interface Deployment                 Question # 3 of 10 Horizontally wide data means: Select correct option: Dataset has large no. of attributes Dataset has large no. of records Dataset has attribute skews Dataset has partitioning skews                 Question # 4 of 10 Which of the following is NOT one of the top-10 mistakes that should be avoided during DWH development? Select correct option: Not interacting directly with end ...

CS614 Quiz No.4 Shared by MT Khan (Solved)

Question # 1 of 10 ( Start time: 09:04:39 PM ) Total Marks: 1 A typical cycle of implementing the change in DWH comprises of the sequence: Select correct option: Production -> QA -> Development Development-> QA -> Production(CORRECT) Development -> Production -> QA Production -> Development -> QA Question # 2 of 10 ( Start time: 09:05:16 PM ) Total Marks: 1 Vertically wide data means: Select correct option: Dataset has large no. of attributes Dataset has large no. of records(CORRECT) Dataset has attribute skews Dataset has partitioning skews Question # 3 of 10 ( Start time: 09:05:43 PM ) Total Marks: 1 In ___________ phase of kimballs approach, we identify the components needed now and in future. Select correct option: Requirement definition Architectural design Product development Analytical application development Question # 4 of 10 ( Start time: 09:06:56 PM ) Total Marks: 1 Technical architecture design supports the communicat...

CS614 Quiz No.3 Shared by Students (Solved), Spring 2014

______ index stores first value in each block in the sequential file and a pointer to the block.  Select correct option:   Dense  Sparse  B-Tree  Hash In context of data parallelism, the work done by query processor should be:  Select correct option:  Almost zero  Maximum  Pipelined  Filtered across partitions The optimizer uses a hash join to join two tables if they are joined using an equijoin and  Select correct option:   Outer table has less number of rows  Inner table has less number of rows  Cardinality of tables is equal  Large amount of data needs to be joined Bitmap index is appropriate for:  Select correct option:  Low cardinality data  High cardinality data  Clustered data  Aggregated data If a task takes “T” time units to execute on a single data item, then execution of this task on “N” data items will take __...