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


    Question

    A snowflake schema differs from a star schema mainly

    because:
    A Snowflake has a single fact table only Correct Answer Incorrect Answer
    B Snowflake further normalizes dimension tables into multiple related tables Correct Answer Incorrect Answer
    C Snowflake removes fact tables entirely Correct Answer Incorrect Answer
    D Snowflake is used only for OLTP systems Correct Answer Incorrect Answer
    E Snowflake uses NoSQL storage Correct Answer Incorrect Answer

    Solution

    Snowflake normalizes dimensions (splitting them) to reduce redundancy at the cost of more joins.

    Practice Next
    ask-question