๐Ÿ“ข Too many exams? Donโ€™t know which one suits you best? Book Your Free Expert ๐Ÿ‘‰ call Now!

  • google app store apple app store
  • โœ–

      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