Scribd Logo
Upload

Welcome to Scribd!

  • 15 views

    DW Que

    Uploaded by

    Raji
    This document contains an internal assessment test for a Data Warehousing course. The test has 3 parts - Part A contains 7 multiple choice questions assessing basic concepts of data warehousing. Part B contains 2 case study questions assessing components, architecture, and processes in more depth. Part C contains 2 questions comparing different architectures and transactional vs analytical databases. The document provides information on the course code, title, duration, date, outcomes assessed, and Bloom's Taxonomy levels for each question.

    Copyright:

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

    DW Que

    Uploaded by

    Raji
    15 views1 page
    This document contains an internal assessment test for a Data Warehousing course. The test has 3 parts - Part A contains 7 multiple choice questions assessing basic concepts of data warehousing. Part B contains 2 case study questions assessing components, architecture, and processes in more depth. Part C contains 2 questions comparing different architectures and transactional vs analytical databases. The document provides information on the course code, title, duration, date, outcomes assessed, and Bloom's Taxonomy levels for each question.

    Original Description:

    DAT WHAREHOUSE QUESTION

    Original Title

    DW QUE

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains an internal assessment test for a Data Warehousing course. The test has 3 parts - Part A contains 7 multiple choice questions assessing basic concepts of data warehousing. Part B contains 2 case study questions assessing components, architecture, and processes in more depth. Part C contains 2 questions comparing different architectures and transactional vs analytical databases. The document provides information on the course code, title, duration, date, outcomes assessed, and Bloom's Taxonomy levels for each question.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    15 views1 page

    DW Que

    Uploaded by

    Raji
    This document contains an internal assessment test for a Data Warehousing course. The test has 3 parts - Part A contains 7 multiple choice questions assessing basic concepts of data warehousing. Part B contains 2 case study questions assessing components, architecture, and processes in more depth. Part C contains 2 questions comparing different architectures and transactional vs analytical databases. The document provides information on the course code, title, duration, date, outcomes assessed, and Bloom's Taxonomy levels for each question.

    Copyright:

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

    NELLIANDAVAR INSTITUTE OF TECHNOLOGY, PUDHUPALAYAM

    DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING


    INTERNAL ASSESSMENT TEST – I

    COURSE CODE: CCS341 MARKS :60


    COURSE TITLE: DATA WAREHOUSING DURATION:90Mins
    YEAR/SEM: III/V DATE: 12-09-2023
    BT
    Q.NO. QUESTION MARKS CO
    LEVEL
    PART - A
    1 What is Data Warehousing? and its characteristics? 2 CO1 BT2
    2 What are the Benefits and drawback of the snowflake schema? 2 CO1 BT2
    3 What are the elements of a modern data warehouse? 2 CO1 BT1
    4 What are uses of operational database? 2 CO1 BT1
    5 Explain ETL. 2 CO2 BT2
    6 Compare Top Down and Bottom Up Approach. 2 CO2 BT4
    7 What are the delivery process in a data warehouse? 2 CO2 BT1
    PART- B
    11.a) Differentiate between operational database Vs data warehouse? 11 CO1 BT4
    OR

    b) What are the different components of data warehouse explain in detail. 11 CO1 BT2

    12. a) Explain in detail data warehouse architecture? 11 CO2 BT1


    OR

    b) Explain in detail autonomous data warehouse? 11 CO2 BT2


    i)Explain ETL process with neat diagram?
    13.a) 11 CO2 BT4
    ii)Compare ETL Vs ELT

    OR
    i)What are the types of data warehouse?
    b) 11 CO2 BT2
    ii)Explain data modelling life cycle.

    PART-C

    14.a) Explain different types of data warehouse architecture in detail 13 CO1 BT1

    OR

    b) Differentiate OLTP Vs OLAP. 13 CO2 BT4


    COURSE OUTCOMES:
    SL.NO QUESTION NUMBER CO'S
    1 1,2,3,4,11.a),b),12.a,.b),14.a) CO1
    2 5,6,7,13.a),b),14.b) CO2
    BLOOM’S TAXONOMY:
    BT1-Remember, BT2- Understand, BT3 –Apply, BT4 - Analyze, BT5-Evaluate, BT6 - Create
    Level BT1 BT2 BT3 BT4 BT5 BT6
    Percentage 28% 49% - 23% - -

    COURSE INSTUCTOR HOD PRINCIPAL

    You might also like