CS614 FINAL TERM CURRENT PAPER 2012
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
ix) Transient cookie & persistent cookie
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
Transient cookie & persistent cookie
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
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
10) Import/export wizard tasks?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
13) Persistent cookies limitatioins?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)
Define Dense and Sparse index, adv and disadv (3)
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)
SQL server meta services advantages(3)
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.
1. 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. 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
____________________________________________________________
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
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
ix) Transient cookie & persistent cookie
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
if any1 have--Hina BilalMIT 3rd semesterAlwayzz think higher than otherzz' expectationzz
--
You received this message because you are subscribed to the Google Groups "Pak Youth" group.
To post to this group, send email to pak-youth@googlegroups.com.
To unsubscribe from this group, send email to pak-youth+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/pak-youth?hl=en.
Zindagi mein 2 Logo ka buhat khayal rahkoooo
2nd woh jiss ko tum ney har dukh me pukaara hoo (Mother)
--
You received this message because you are subscribed to the Google Groups "Pak Youth" group.
To post to this group, send email to pak-youth@googlegroups.com.
To unsubscribe from this group, send email to pak-youth+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/pak-youth?hl=en.
No comments:
Post a Comment