๐Ÿ“ข Too many exams? Donโ€™t know which one suits you best? Book Your Free Expert ๐Ÿ‘‰ call Now!

  • google app store apple app store
  • โœ–

      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