Scribd Logo
Upload

Welcome to Scribd!

  • 13 views

    CCS341 DATA WAREHOUSING FIRST INTERNAL QUESTION Set 1

    Uploaded by

    ummulhfathima.msec
    INTERNAL QUESTION

    Copyright:

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

    CCS341 DATA WAREHOUSING FIRST INTERNAL QUESTION Set 1

    Uploaded by

    ummulhfathima.msec
    13 views2 pages
    INTERNAL QUESTION

    Original Title

    CCS341 DATA WAREHOUSING FIRST INTERNAL QUESTION set 1 (1)

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    INTERNAL QUESTION

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    13 views2 pages

    CCS341 DATA WAREHOUSING FIRST INTERNAL QUESTION Set 1

    Uploaded by

    ummulhfathima.msec
    INTERNAL QUESTION

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 2

    DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

    INTERNAL ASSESSMENT TEST – II SET - 1


    SUBJECT CODE/NAME:CCS341 / Data Warehousing DATE : 04.04.2024
    BRANCH / SEMESTER: CSE / VI TIME: 09.45 AM to 11.15 AM

    ACADEMIC YEAR : 2023 – 2024 Even Semester MARKS : 50

    CO3 : Analyze the partitioning strategy


    CO4: critically analyze the differentiation of various schema for given problem.
    BLOOM'S TAXONOMY
    Remembering Applying Evaluating
    Understanding Analyzing Creating
    PART A (5 x 2 = 10 Marks)
    CO3 U 1. Discuss the challenges for meta data. (2)
    CO3 R 2. Write short notes on normalization. (2)
    CO4 R 3. Define data cube. (2)
    CO4 R 4. Which one of the data warehouse schema is more popular? Why? (2)
    CO4 E 5. List out the data warehouse tools. (2)
    PART B (2*13 = 26 Marks)
    CO3 U 6.a Explain in detail about meta data management. (13)
    (OR)
    CO3 R 6.b Write detailed notes on designing of data mart. (13)
    CO3 U 7.a Discuss about partitioning strategy. (13)
    (OR)
    CO4 E 7.b Evaluate the importance of Multi dimensional data model. (13)
    PART C (1*14 = 14 Marks)
    Discuss about the data warehouse design schemas
    i. Star schema & Snowflake schema 7+7
    CO4 U 8.a
    ii. Fact Constellation Schema

    (OR)
    CO4 U 8.b Summarize the Process architecture and Database parallelism. (14)

    Prepared By Verified By COE Approved By

    Dr. V.BALAMURUGAN Dr. M.VIJAYARAJ


    Define data cube.
    Differentiate star schema and snowflake schema
    List out the data warehouse tools

    You might also like