Multiple choice technology

What does a Fact table contain?

  1. Tables typically contain facts and primary keys to the dimension tables

  2. Tables typically contain facts and foreign keys to the dimension tables

  3. Tables containing detail level facts or facts that have been aggregated

  4. None

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

Fact tables store quantitative measurements or metrics (facts) along with foreign key references to dimension tables. These foreign keys connect each measurement record to its dimensional context (e.g., which product, which customer, which time period). Facts are typically numeric and additive across dimensions.