Skip to main content

CS614 Current Finalterm Paper Spring 2014 Shared By Shehzadi


AOA To ALL...
My 2day Cs614 Paper:
Objective All Most Moaaz File Few New But Easy...
Suppose There Is A Large Enterprise Which Uses The Same Server For The Development And Production Environments. What Problems Can Arise If It Uses Single Server For Both Purposes? 5m
Write Down Any Two Drawbacks If “Date” Is Stored In Text Format Rather Than Using Proper Date Format Like “Dd-MMM-Yy” Etc. 5m
In Context Of Web Data Warehousing, Consider The “Web Page” Dimension, List At Least Five Possible Attributes Of This Dimension. 5m
There Are Different Data Mining Techniques E.G. “Clustering”, “Description” Etc. Each Of The Following Statement Corresponds To Some Data Mining Technique. For Each Statement Name The Technique The Statement Corresponds To. 5m
A) Assigning Customers To Predefined Customer Segments (I.E. Good Vs. Bad)
B) Assigning Credit Applicants To Predefined Classes (I.E. Low, Medium, Or High Risk)
C) Guessing How Much Customers Will Spend During Next 6 Months
D) Building A Model And Assigning A Value From 0 To 1 To Each Member Of The Set. Then Classifying The Members Into Categories Based On A Threshold Value.
E) Guessing How Much Students Will Score More Than 65% Grades In Midterm.
Specify At Least One Implication, If You Don’t Provide Proper Documentation As Part Of Data Warehouse Development.3 M
In Context Of Nested Loop Join, Mention Two Guidelines For Selecting A Table As Inner Table. 3m
We Can Identify The Session In Word Wide Web By Using “Time-Contiguous Log Entries” However There Are Some Limitations Of This Technique. Briefly Explain Any Two Limitations. 3m
Identify The Given Statement As Correct Or Incorrect And Justify Your Answer In Either Case.
"The Problem Of Referential Integrity Always Occurs In Traditional OLTP System As Well As In DWH". 3m
There Are Two Primary Techniques For Gathering Requirements I.E. Interviews Or Facilitated Sessions. Which Technique Is Preferred By Ralph Kimball? 2m
List Down Any Two Parallel Software Architectures?2m
List Down Any Four Static Attributes Recorded By The Scouts In Agriculture Data Warehouse Case Study. 2m
List Down Any Four Issues Of Clickstream Data. 2m
Remember For Me And Best Of Luck...


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