Multiple choice technology

What is the difference between fact tables and dimension tables?

  1. Facts has the measure and dimension have attributes

  2. Facts are the slowly changing and dimensions are constantly changing

  3. Fact are less in size and dimensions are more in size

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Fact tables contain quantitative measures (metrics like sales, revenue) while dimension tables contain descriptive attributes (like product, time, location). Dimensions describe the facts, providing context. Dimensions typically change slowly (slowly changing dimensions), while facts accumulate rapidly. Fact tables are usually much larger than dimension tables.

Keep practicing — related questions