Multiple choice technology

The Key which uniquely identifies each entity in the dimension table regardless of its source key is called

  1. Surrogate Key

  2. Primary Key

  3. Composite Key

  4. Foreign key
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A surrogate key is a system-generated unique identifier that exists independently of any source or natural key. Unlike natural keys which may be composite, change over time, or have business meaning, surrogate keys provide consistent, immutable identification for each dimension table row regardless of the data source.

Keep practicing — related questions