DEV Community

Cover image for Data Warehousing and Data Mining
ANIRUDDHA ADAK
ANIRUDDHA ADAK

Posted on • Edited on

Data Warehousing and Data Mining

#database #datascience #dataengineering #learning

15-Marks Questions (Frequency >= 3)

  1. Frequency: 6

    • Question: a) Introduce the concept of data mining and cite two application areas. b) What are the different steps of a data mining task? c) Suppose that the data mining task is to cluster the following eight points (with (x, y) representing location) into 3 clusters. ... Use k-means algorithm to determine the three clusters.
    • WBUT Years: [2010, 2012, 2013, 2014, 2016, 2018]
    • Source Page: 9 (Long Answer Type Questions, Q3)

  2. Frequency: 6

    • Question: a) What is clustering? Why is it required for data warehousing and data mining? What are the differences between partitioning clustering and Hierarchical clustering? OR, What is clustering? What are the features of good cluster? What do you mean by hierarchical clustering technique?
    • WBUT Years: [2009, 2013, 2014, 2016, 2017, 2018]
    • Source Page: 26 (Long Answer Type Questions, Q1a) & 28 (Long Answer Type Questions, Q2a)

  3. Frequency: 3

    • Question: a) Define decision tree. b) What are the advantages and disadvantages of the decision tree approach over other approaches for data mining? c) Discuss briefly the tree construction principle. OR, Describe the basic algorithm for decision tree induction. d) What is a classification problem? What is the difference between supervised and unsupervised classification?
    • WBUT Years: [2009, 2010, 2013]
    • Source Page: 35 (Long Answer Type Questions, Q1)

  4. Frequency: 3

    • Question: b) Discuss the principle of FP-tree Growth algorithm. OR, Discuss the different phases of FP-tree growth algorithm. OR, Define FP tree. Discuss the method of computing FP tree.
    • WBUT Years: [2010, 2012, 2018]
    • Source Page: 40 (Long Answer Type Questions, Q3b)

5-Marks Questions (Frequency >= 3)

  1. Frequency: 5

    • Question: Define Data Marts. Define the types of Data Marts.
    • WBUT Years: [2009, 2010, 2011, 2015, 2018]
    • Source Page: 4 (Short Answer Type Questions, Q1)

  2. Frequency: 4

    • Question: What are the differences between OLAP & OLTP?
    • WBUT Years: [2009, 2011, 2013, 2017]
    • Source Page: 67 (Short Answer Type Questions, Q2)

  3. Frequency: 4

    • Question: c) Text mining (as a short note).
    • WBUT Years: [2009, 2012, 2015, 2017]
    • Source Page: 15 (Short Answer Type Questions, Q5c)

  4. Frequency: 3

    • Question: What is an Association Rule? Define Support, Confidence, Item set and Frequent item set in Association Rule Mining? (Includes OR variants)
    • WBUT Years: [2009, 2013, 2017]
    • Source Page: 5 (Short Answer Type Questions, Q3)

  5. Frequency: 3

    • Question: How is data warehouse different from a database?
    • WBUT Years: [2013, 2016, 2018]
    • Source Page: 7 (Short Answer Type Questions, Q8)

  6. Frequency: 3

    • Question: b) Arbor Essbase Web (as a short note).
    • WBUT Years: [2012, 2015, 2017]
    • Source Page: 69 (Short Answer Type Questions, Q2b)

Top comments (0)