--Your friends at LectureNotes

Previous Year Exam Questions of Data Mining And Data Warehousing of bput - DMDW by Verified Writer

  • Data Mining And Data Warehousing - DMDW
  • 2017
  • PYQ
  • Biju Patnaik University of Technology Rourkela Odisha - BPUT
  • Computer Science Engineering
  • B.Tech
  • 312 Offline Downloads
  • Uploaded 1 year ago
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

Text from page-1

Registration No: Total Number of Pages: 02 B.Tech PCS5H002 5th Semester Regular Examination 2017-18 Datamining & Data Warehousing BRANCH: CSE Time: 3 Hours Max Marks: 100 Q.CODE: B307 Answer Question No.1 and 2 which are compulsory and any four from the rest. The figures in the right hand margin indicate marks. Q1 a) b) c) d) e) f) g) Answer the following questions: multiple type or dash fill up type Which of the following is the most important when deciding on the data structure of a data mart? (a) XML data exchange standards (b) Data access tools to be used (c) Metadata naming conventions (d) Extract, Transform, and Load (ETL) tool to be used The process of removing the deficiencies and loopholes in the data is called as (a) Aggregation of data (b) Extracting of data (c) Cleaning up of data. (d) Loading of data (e) Compression of data. Which one manages both current and historic transactions? (a) OLTP (b) OLAP (c) Spread sheet (d) XML Which of the following is the collection of data objects that are similar to one another within the same group? (a) Partitioning (b) Grid (c) Cluster (d) Table (e) Data source. Which of the following process includes data cleaning, data integration, data selection, data transformation, data mining, pattern evolution and knowledge presentation? (a) KDD process (b) ETL process (c) KTL process (d) MDX process (e) None of the above. Data mining application domains are (a) Biomedical (b) DNA data analysis (c) Financial data analysis (d) Retail industry and telecommunication industry (e) All (a), (b), (c) and (d) above. Which of the following is not an ETL tool? (a) Informatica (b) Oracle warehouse builder (c) Datastage (d) Visual studio (e) DT/studio. (2 x 10)

Text from page-2

h) i) j) Q2 Which of the following is/are the Data mining tasks? (a) Regression (b) Classification (c) Clustering (d) inference of associative rules (e) All (a), (b), (c) and (d) above. Which of the following should not be considered for each dimension attribute? (a) Attribute name (b) Rapid changing dimension policy (c) Attribute definition (d) Sample data (e) Cardinality. Which of the following is the collection of data objects that are similar to one another within the same group? (a) Partitioning (b) Grid (c) Cluster (d) Table (e) Data source. i) j) Answer the following questions: Short answer type How is a data warehouse differ from a database ? Distinguish the feature between OLAP & OLTP . List data warehouse backend tools and its utilities and their functions. What is business intelligence ? What do you mean by neural clustering? Mention the utility of knowledge base. What is the drawback of using separate set of samples to evaluate pruning. List any two software tools associated with data mining and highlight their features. What are the steps involved in KDD process? Define meta data. Q3 a) b) Describe the architecture and implementation of data warehouse. Briefly explain the basic dimensional modeling techniques. (10) (5) Q4 a) b) Explain the algorithm for constructing a decisions tree from training samples. Describe the K-Mean clustering algorithm. (10) (5) Q5 a) (10) b) What do you mean by data mining functionality ? Explain with suitable examples. Explain OLAP operations in Multidimensional Data Model. Q6 a) b) Explain the classification of major clustering methods. Explain briefly about various steps of Data Mining process. (10) (5) Q7 a) b) What is the role of data mining in spatial database ? Detail on Data Warehouse meta data. (10) (5) Q8 a) b) Explain in details about text mining applications. How is web usage mining different from web structure mining and web content mining ? (10) (5) Q9 a) Write short note on : i.Issues regarding classification and prediction. ii.Outlier Analysis. Discuss about social impacts and various trends in Data Mining . (10) a) b) c) d) e) f) g) h) b) (2 x 10) (5) (5)

Lecture Notes