📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!
  • google app store apple app store
    • ✖

      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