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


    âš¡ Month End Offer - Flat 52% Off On All Courses! Enroll Now âš¡
    00:00:00 AM Left

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