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/numerical values and are 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 numerical measurements (facts) and foreign keys that link to dimension tables. Each row typically represents a business event or transaction. Option A is incorrect because fact tables use foreign keys (not primary keys) to reference dimension tables. Option C describes a variation but doesn't capture the essential structure.