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

  • google app store apple app store

    • Question

      In a star schema, what is the primary characteristic of

      the fact table?
      A Contains denormalized textual descriptions Correct Answer Incorrect Answer
      B Stores transactional measures with foreign keys to dimension tables Correct Answer Incorrect Answer
      C Holds slowly changing dimensions only Correct Answer Incorrect Answer
      D Is always normalized to 3NF Correct Answer Incorrect Answer
      E Contains only surrogate keys and no measures Correct Answer Incorrect Answer

      Solution

      Fact table stores numeric measures (facts) and foreign keys referencing dimensions for analysis.

      Practice Next
      ask-question