Scribd Logo
Upload

Welcome to Scribd!

  • 97 views

    DWM

    Uploaded by

    Ankit Shahu
    The document contains a question bank for a data warehousing and mining exam, divided into 2 mark questions and 5 mark questions. The 2 mark questions focus on basic concepts in data warehousing and data mining like definitions of data warehouse, data mart, metadata, data mining techniques like classification. The 5 mark questions require more detailed explanations on topics like data warehousing architectures, dimensional modeling, ETL processes, OLAP systems, schema designs like star and snowflake schemas. They involve designing schemas for various domains like retail, education, healthcare to assess understanding of dimensional modeling concepts.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    DWM

    Uploaded by

    Ankit Shahu
    97 views3 pages
    The document contains a question bank for a data warehousing and mining exam, divided into 2 mark questions and 5 mark questions. The 2 mark questions focus on basic concepts in data warehousing and data mining like definitions of data warehouse, data mart, metadata, data mining techniques like classification. The 5 mark questions require more detailed explanations on topics like data warehousing architectures, dimensional modeling, ETL processes, OLAP systems, schema designs like star and snowflake schemas. They involve designing schemas for various domains like retail, education, healthcare to assess understanding of dimensional modeling concepts.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains a question bank for a data warehousing and mining exam, divided into 2 mark questions and 5 mark questions. The 2 mark questions focus on basic concepts in data warehousing and data mining like definitions of data warehouse, data mart, metadata, data mining techniques like classification. The 5 mark questions require more detailed explanations on topics like data warehousing architectures, dimensional modeling, ETL processes, OLAP systems, schema designs like star and snowflake schemas. They involve designing schemas for various domains like retail, education, healthcare to assess understanding of dimensional modeling concepts.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    97 views3 pages

    DWM

    Uploaded by

    Ankit Shahu
    The document contains a question bank for a data warehousing and mining exam, divided into 2 mark questions and 5 mark questions. The 2 mark questions focus on basic concepts in data warehousing and data mining like definitions of data warehouse, data mart, metadata, data mining techniques like classification. The 5 mark questions require more detailed explanations on topics like data warehousing architectures, dimensional modeling, ETL processes, OLAP systems, schema designs like star and snowflake schemas. They involve designing schemas for various domains like retail, education, healthcare to assess understanding of dimensional modeling concepts.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    Question Bank- IAT1 (DWM)

    2 Marks questions :-
    1. What is data ware house?
    2. Draw the block diagram of data warehouse
    3. What is data mart?
    4. What is meta data?
    5. What is operational meta data?
    6. What is data mining?
    7. What are junk dimensions?
    8. What is surrogate key?
    9. What is factless fact table? Explain with example.
    10. What is technical metadata?
    11. What is extraction and transformation metadata?
    12. What are the disadvantages of top down approach?
    13. What are the disadvantages of bottom up approach?
    14. What are advantages of top down approach?
    15. What are advantages of bottom up approach?
    16. What are the differences between Data Warehouse and Data Mart?
    17. What is fact constellation? Explain with example.
    18. What is data mining?
    19. What is classification? Explain with example.

    5 Marks Question:-
    1. Give the architecture of typical DM system.
    2. Describe the steps in KDD process with suitable block diagram
    3. Compare OLTP and OLAP systems
    4. A dimension table is wide and fact table is deep. Explain.
    5. Write a short note on snowflake schema.
    6. Design star schema for autosales analysis.
    7. What is dimensional modelling? Explain in detail.
    8. Explain information package diagram with example.
    9. State and explain the various schemas used in data warehousing
    10. Describe different methods to do updates in dimension tables
    11. Explain how slowly changing dimensions are dealt in data warehousing
    12. Draw a star schema for student academic fact database
    13. List the dimensions and facts for clinical information system and design star and snow flake
    schema
    14. Compare ERmodel and dimension model
    15. Write detailed note on data ware house architecture
    16. Explain the characteristics of data present in data warehouse
    17. Write a short note on top down and bottom up approaches
    18. For a super market chain, consider the following dimensions, namely product, store, time,
    promotion. The schema contains a central fact table, sales facts with three measures
    unit_sales, dollar_sales, dollar_cost. Design star schema for this application.
    19. Design the star schema for Mumbai university.
    20. Design star schema for hotel occupancy
    21. Design star schema for supermarket chain
    22. Design star schema for library management
    23. Design star schema for bank
    24. Draw star schema for video rental
    25. Design star schema for a chain of bookstores
    26. Define the aggregate fact table by giving examples
    27. Discuss various OLAP models and their architectures

    28.

    29.

    30. Explain updates of dimension tables in detail.

    31. Explain Naïve Bayes Classification. Also write advantages and disadvantages of it.
    32. Sums on Naïve Bayes Classification.
    33. Explain all ETL functions in detail.

    You might also like