We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

www.vustudents.ning.com

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

# CS614 plz share ur current paper here 2012

Stay blessed and Best of Luck for final exam.

Best Regards,

sana

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

Views: 780

### Replies to This Discussion

i)       K-mean weakness

ii)     Classification process and its accuracy?

iii)   Diff b/w data matrix & similarity/dissimilarity matrix

iv)   Name of authority to pest

v)     Do you think it will create the problem of non-standardized attributes, if one source uses 0/1 and second source uses 1/0 to store male/female attribute respectively? Give a reason to support your answer.

vi)   Inverted index

vii) Diff b/w knowledge Discovery,data mining and DWH

viii)           Why DASD is better thn tape storage w.r.t access time

x)     How Business validation rule implemented in DTS?

xi)   clickstream

xii) Data profiling is a process of gathering information about columns, what are the purpose that it must fulfill? Describe briefly

• K-mean weakness
• Classification process and its accuracy?
• Diff b/w data matrix & similarity/dissimilarity matrix
• Name of authority to pest
• Do you think it will create the problem of non-standardized attributes, if one source uses 0/1 and second source uses 1/0 to store male/female attribute respectively? Give a reason to support your answer.
• Inverted index
• Diff b/w knowledge Discovery,data mining and DWH
• Why DASD is better thn tape storage w.r.t access time
• How Business validation rule implemented in DTS?
• clickstream
• Data profiling is a process of gathering information about columns, what are the purpose that it must fulfill? Describe briefly
cs614 final term papers

All MCQs were new only 4 were from past papers.
Q.1: Exlpain anayletic dta application specification in kimbill 5 marks
Q2: Bisinuss rules are validated using student database in LAB 5 marks
Q3: 2 real life examples of clustring . 5 marks
Q4: purposes dta data profiling 3 marks
Q5: Wwhat issues may accour during data acquisition and cleansing in agriculture case study? 3marks
Q6: Meant of classification process,How measure accuracy of classification? 3marks
Q7: Data parralism explain with example 3 marks
Q8: Under wahat condition an operation can be excute in parallel? 3 marks
Q9: What sorts of objectives metric are use by companies what are possible issues in formulation these metric? 2 marks
Q10: which script language are used to perfirm complex transformation in DTS pachage? 2 marks
Q11: Cleasing can be break down in Who many steps, write their names? 2 marks
Q12: What do u mean by “ keep competition hot in ontext of production selection and transformation while designing a data warehouse “. 2 marks
Q13: Who murge column are selected in case of sort merge? 2 marks
1) What are the fundamental weaknesses of k means clustering? 2
2) what are the two extremes for technical architecture design? 2
3) Different b/w non key or key data access?2
4) “Be a diplomat not a technologist”?2
5) Dirty bit?2
6) What are the problem face industry when the growth in usage of
master table file increase?3
7) Indexing using I/0 bottelneck?3
Implementation strategies 3
9) W8 is Click stream? Limitations?3
11) Problem using SQL to fill up tables of ROLAP cube?3
12) How data mining is different from statics?which one is better?5
14) Analytical development phase of Kimbal?5

Q1why a pilot project strategy is highly recommended in DWH construction? 5
Q2define nested loop join list and describe its variants? 5
Q3describe how business rule are validated using student database in lab lecture? 5
Q4keeping view the uniform distribution in hash based partition .if the partitions are not
unformly distributed across the process? 3
Q5what are the task performed through import export data wizard to load data? 3
Q6what is mean by click stream? how it can be useful in a web DWH environment? 3
Q7what is mean by the classification process?how we measure the accuracy of classifiers? 3
Q8discuss need for indexing with reference to i/o speed? 3
Q9IN ROUND ROBIN THE DISTRIBUTION IS Pre DEFINED. DO YOU AGREE OR NOT SUPPORT YOUR ANSWER WITH REASON? 2
Q10what are major operation of data mining? 2
Q11which scripting language are used to perform complex transformation in DST package? 2
Q12a person wanted to visit and understand the data warehouse implementation strategies adopted in that organization has refused to allow . what may be the carrier of this refusal?
Q13how the application of parallelism differ for OLTP and DSS environment? 2
My today CS614- Data Warehousing Paper
Most of the objective were from old papers.
Very less came from mid term course. all subjective from end term
so better to concentrate more on end term papers
Issues of cluster index (2)
Weaknesses of K-mean clustering(3)
Strength and weaknesses of k-mean clustering(5)
Partition Skew Hash(3)
Fixed strategy of standardizing column(2)
Be a diplomat and not technologist(2)
Issued faced in data cleansing of AgriDWH(3)
Problems which may face in construction of AgriDWH(3)
Why pilot strategy is recommended for construction of DWH(5)
Purpose of DTS services(5)

my  paper 3 feb 2012

Total 53 questions nd paper total marks 80. 40 mcqs, 5 ques 2 marks, 5 ques 3 marks and 3 ques 5 marks.

1Do you think it will create the problem of non-standardized attributes, if one source uses 0/1 and second source uses 1/0 to store male/female attribute respectively? Give a reason to support your answer. 2 marks

2. How the three parallel tracks capture the user requirements in the Kimball s data
warehouse life cycle Road Map / three parallel techniques. 5 marks

3. Transient and persistence cookies also limitations of those cookies. 5 marks

4.data profiling nd purposes of data profiling.  3 marks

5.how the queries are differ for OLTP and DWH environment? Or diff b/w OLTP nd DWH? 2 marks

6.Write down the steps which are performed in clustering process. 3 marks

7. Give name of activities to be performed in planning and design phase as discussed in agri-DWH case study. 3 marks

8. problem in Partition Skew based Hash join. 3 marks

9. total quality management. How total quality management technique is differ nd better from old management techniques. 2 marks

10. b-tree indexing limitations. 2 marks

11. roll out and maintainance phase of agri DWH. 3 marks

12. Data Transformation Services (DTS) provide a set of  tools, Packages, tasks and connections that lets you extract, transform, and consolidate data from disparate sources into single or multipledestinations supported by DTS connectivity 5 marks

i)       How Business validation rule implemented in DTS? 5

ii)     Clickstream? how it is useful in a web dwh environment. 3

iii)   Data profiling is a process of gathering information about columns, what are the purpose that it must fulfill? Describe briefly 5

iv)   Why a Pilot project strategy Is highly recommended in dwh construction. 5

v)     Need for indexing with reference to i/o speed  3

vi)   Analytic application development 5

vii) Two extremes for tech. arch. Design, which one is better 2

viii)           Which script language is used to perform complex transformation in dts package 2

ix)   What types of operations are performed by MS DTS. 3

x)     Name of the pest scouting org and the year of its starting. Answer DPWQCP 1984, 2 marks

Attachments:

3rd feb CS614 ke kuch subjective questions

1. Gve name of activitiz 2 b perfrmd in planing nd dezin phase as dscsd in agri.dwh case study
2. What r gud feature of holap from other tekniqs
3. Docoment archtechr requrment of kimbl modal wd an expl
... ... 4. Task perfrmd through import expnrt data wizard to load data?
5. How clasifcatn difr frm estimation
ye dosre dost ke question h
Agri dwh data cleasing y required?
Data wizard requirmt to load data?
Dense and sparse index?
Analytical aplication of kimbal?
Waterfal method can be used for dwh?
Query to select females from dwh?
3 marks appli of clustring, meta deta service advantg, table width increas issues, test phase in agri data, name of authority to pest . . . .
2 marks script languages, k means weaknes, growth usage in datawarehouse, baqi 2 q yad nh
5 marks lesson agri data, 7 steps dts wizard, diff data matrix nd similiar/dissmlr matrix which öne is symetric

one more paper of CS614
i) K-mean weakness

ii) Classification process and its accuracy?
...
iii) Diff b/w data matrix & similarity/dissimilarity matrix

iv) Name of authority to pest

v) Do you think it will create the problem of non-standardized attributes,

if one source uses 0/1 and second source uses 1/0 to store male/

female attribute respectively? Give a reason to support your

vi) Inverted index

vii)Diff b/w knowledge Discovery,data mining and DWH

viii)

Why DASD is better thn tape storage w.r.t access time

x) How Business validation rule implemented in DTS?

xi) clickstream
xii)Data profiling is a process of gathering information about columns,
what are the purpose that it must fulfill? Describe briefly

my today paper of cs614

subjective portion:

1) what is the basic concept of inverted index? 2 marks

2) why analytic track is called the "funpart" while designing a data warehouse? 2

3) why you need to analyze the web traffic at lowest level? 2

4) what will be the effect if we program a package by using DTS object model? 2

5) how grain is related with expressiveness? 2

6) differentiate between knowledge discovery in data base, data mining and data warehouse?3

7) why building a data warehouse is challenging activity what are three broad catagories of datawarehouse development method? 3

8) data profiling process? 3

9) Give name of activities of to be performed in building and testing phase as discussed in agri- DWH case study? 3

10) suppose you want to enhance performance of data warehouse which strategy throwing more hardware or aggregation will be used? 3

11) what are the fundamental strengths and weakness of k mean clustering? 5

12) write a query to extract total number of female students in BS telecom? 5

13) describe the lessons learnt during agri- datawarehouse case study? 5

some short questions of another cs614 today paper

1) single clustering double clustering

2) one to one transformation, one to many transformation

3) DTS benefits and usage

4) K technique benefits and drwabacks.

5) Business laws in students labs

6) be a technologist is necessary in the DWH

7) clicking stream in web DWH

7-2-12 cs614 paper

70 % of MCQs were from old papers

Some of the Question that i can remember are

what are the two extremes for technical architecture design?
Strength and weaknesses of k-mean clustering
Partition Skew Hash
Problems which may face in construction of Agri DWH
Write two extremes of Tech.Arch Design?
in how many ways a user can access web data.
difference between MOLAP and DOLAP
Write SQL Query to find all Female student in BS telecom.

.

1.Difrence b/w MOLAP and DOLAP implementation 2marks
2.What are three methods for creating a DTS package? 2marks
3.Difrenc b/w classification and clustering 2 marks
4.Difrenc b/w classification and clustering 2 marks
5.Waterfal method can be used for dwh? 2 marks
6. Data profiling is a process of gathering information about columns,
what are the purpose that it must fulfill? Describe briefly 3 MArks
7. W8 is Click stream? How it is use in DWH WEB? 3marks kuch is terha ka tha main
iski limitaion likh aya
8.Diff b/w knowledge Discovery,data mining and DWH. 3 Marks
9.Value valdiation process is importnat for data warehouse or not?justify ur answer.3 marks
10.WHAT are the methjod of developing DHW? 3marks
ANSWER: DATA DRIVEN, USER DRIVEN, GOAL driven
11.Why a pilot project strategy is highly recommended in DWH construction? 5marks
12.Explain Analytic Applications D

CS614 Fall 2011 Final Term Feb 2012 – VU Current Paper – 03 Feb 2012
1. K-mean weakness
2. Classification process and its accuracy?
3. Diff b/w data matrix & similarity/dissimilarity matrix
4. Name of authority to pest
5. Do you think it will create the problem of non-standardized attributes, if one source uses 0/1 and second source uses 1/0
to store male/female attribute respectively? Give a reason to support your answer.
6. Inverted index
7. Diff b/w knowledge Discovery,data mining and DWH
8. Why DASD is better thn tape storage w.r.t access time
10. How Business validation rule implemented in DTS?
11. clickstream
12. Data profiling is a process of gathering information about columns, what are the purpose that it must fulfill? Describe
briefly

waowwwwwwwww

## Latest Activity

14 minutes ago
19 minutes ago
20 minutes ago
20 minutes ago
+M.Tariq Malik added a discussion to the group CS501 Advance Computer Architecture

### CS501 Assignment 01 Fall 2020 Solution / Discussion Due Date: 30-11-2020

21 minutes ago
+ " J i y a " ♥ posted photos
29 minutes ago
Ashraf Butt, sara khan, jawad ali and 14 more joined Virtual University of Pakistan
39 minutes ago
42 minutes ago
43 minutes ago
43 minutes ago
مخلص posted a discussion

44 minutes ago
52 minutes ago

1

2

3