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

    Question

    Surrogate keys are used in data warehouses

    because:
    A They are always smaller than natural keys Correct Answer Incorrect Answer
    B They provide stable, system-generated identifiers independent of source system keys Correct Answer Incorrect Answer
    C They guarantee uniqueness across schemas Correct Answer Incorrect Answer
    D They automatically enforce constraints Correct Answer Incorrect Answer
    E They prevent data skew Correct Answer Incorrect Answer

    Solution

    Surrogate keys are artificial identifiers (like sequence IDs) used to maintain consistency and stability even if source keys change.

    Practice Next
    More Data Warehousing Questions
    ask-question