📢 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 main advantage of using

    surrogate keys in fact tables?
    A Reduce query time with indexes Correct Answer Incorrect Answer
    B Allow natural key reuse across dimensions Correct Answer Incorrect Answer
    C Maintain referential integrity during slowly changing dimensions Correct Answer Incorrect Answer
    D Optimize ETL processes with uniqueness Correct Answer Incorrect Answer
    E All of the above Correct Answer Incorrect Answer

    Solution

    Surrogate keys are artificial keys used in dimensions to avoid natural key duplication, speed joins, and handle SCDs cleanly.

    Practice Next
    More Data Warehousing Questions
    ask-question