Replies to This Discussion

Advertise Here

Permalink Reply by Yasmeen(S.admin) on February 5, 2012 at 7:02pm

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

Permalink Reply by Yasmeen(S.admin) on February 5, 2012 at 7:03pm

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

Permalink Reply by Yasmeen(S.admin) on February 5, 2012 at 7:04pm

 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)

Permalink Reply by Yasmeen(S.admin) on February 8, 2012 at 11:44am

1) Issue of clustring index 
2) How user access web data 
3) Write an extraction qurey to extract "Kakiyan mean Female" and Course BS 
4) HOLAP k 2 question aaye thay 
5) Dataware house Development k baray mai
n

Permalink Reply by Yasmeen(S.admin) on February 9, 2012 at 12:08pm

Total quiz 53, 40 MCQS, 13 subjective
Q #1: Why “Justification” is required in project planning?
Q #2: Define forward proxy?

Q #3: Is there any fixed strategy to standardize a column?
Q #4: Major operation of data mining?

Q #5: In Round-Robin the distribution is pre-defined, you agree or not? Support your answer.
Q #6: Differentiate in dense index and spars index? What are advantages and disadvantages of these?
Q #7: what is classification process? How we measure the accuracy of classifiers?
Q #8: For what reason trivial quires give wrong result in Agri-DWH? Explain with Example.
Q #9: Purposes of data profiling?
Q #10: TQM benefits? Why organizations prefer this technique on other techniques?
Q #11: How mistakes should avoid in data warehouse process?
Q #12: How time contiguous log entries and HTTP secure socket layer are used for user session identification? Limitation of this.

Permalink Reply by Yasmeen(S.admin) on February 9, 2012 at 12:09pm

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

Permalink Reply by Yasmeen(S.admin) on February 9, 2012 at 12:10pm

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 DWH7) clicking stream in web DWH

Permalink Reply by Yasmeen(S.admin) on February 9, 2012 at 12:12pm

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

Permalink Reply by Yasmeen(S.admin) on February 11, 2012 at 11:52am

Briefly explain the types of constraints that we use in DTS (5)

 

Give single example of DWH of                        (5)

Financial service/insurance

Tale communication

Transportation Company

Government

 

K-men clustering functional strength and weaknesses (5 )

 

What is the task performed bye the import & export data wizard to load data ( 3 )

 

What are the three major applications for accessing information stored on the web ( 3 )

 

 

Differences between one way clustering and two way clustering how they are use   together ( 3 )

 

 

 

Write the Bit Map index advantages   ( 2 )

 

 

Differentiate drill down and pivoting approach ( 2 )

 

 

Explain non standardized attributes of 1/0 and 0/1 stored in attribute library  do what problem  ( 2 )

 

A person want to visit and want to know the DWH of an organization why company refuse to visit his DWH give your argue ( 2 )

 

 

“Keep the Competition HOT “ explain  in Fradut selection and instat ( 2 )

 

 

Skew Problem in hash Join how can be solved ( 2 )