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

  • google app store apple app store

    • Question

      Fact constellation schema is best described

      as:
      A Multiple fact tables sharing dimension tables Correct Answer Incorrect Answer
      B One fact table linked to one dimension Correct Answer Incorrect Answer
      C Snowflake schema with denormalized dimensions Correct Answer Incorrect Answer
      D Fully normalized dimension hierarchy Correct Answer Incorrect Answer
      E Star schema with surrogate facts Correct Answer Incorrect Answer

      Solution

      Fact constellation = “galaxy schema,” where multiple fact tables share dimensions.

      Practice Next
      ask-question