STA630 Current Midterm Paper Shared by Sarf, Spring 2014

Trend of sharing current papers have gone......
But my effort is still to keep it alive.....
My today's paper is as under. Hope someone like me will be benefited. BEST of luck for Mid-Terms....
8 Jun 14, 2nd Session Paper
23 Qs
18 x MCQs
2x 3 Mks and 3x 5 Mks Qs
MCQs mostly new (At-least I couldn't locate any from the files available here)
3Mks Qs were 1. Things to be taken care of in Data Collection. 2. Scenario based Q asking for approach required to be used.
5 Mks Qs.1. Scenario - "Which tea brand is being used by how many people" -
Tell the scale of measurement most suited and also narrate uses of this data for extracting which info.
2. Difference in Theoretical framework and literature review.
3. ---forgot something related to approach in research.

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 __...

Virtual University Forum

Search This Blog