Multiple choice technology

A fact table is linked to a dimension table using

  1. Surrogate keys

  2. Compound keys

  3. Complex keys

  4. None of the above

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In dimensional modeling, fact tables link to dimension tables using surrogate keys - artificially generated keys that are independent of source system keys. Surrogate keys provide stability, performance, and handle slowly changing dimensions better than natural or compound keys.