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

    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
    More Data Warehousing Questions
    ask-question