📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

    Question

    Which type of schema normalizes dimension tables to

    reduce redundancy?
    A Star schema Correct Answer Incorrect Answer
    B Snowflake schema Correct Answer Incorrect Answer
    C Fact constellation schema Correct Answer Incorrect Answer
    D Galaxy schema Correct Answer Incorrect Answer
    E Flat schema Correct Answer Incorrect Answer

    Solution

    Snowflake schema organizes dimension tables in a normalized way, reducing redundancy compared to a star schema.

    Practice Next
    More Data Warehousing Questions
    ask-question