📢 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
    ask-question