In a star schema, which correctly distinguishes FACT tables from DIMENSION tables?
A.Facts store numeric measurements/events; dimensions store descriptive attributes for slicing
Measurements + descriptive context = correct split.
B.Facts store descriptions; dimensions store numbers
Reversed — facts are numbers, dimensions are descriptions.
C.Facts link to other facts; dimensions are unlinked
Dimensions link TO facts — not vice versa as stated.
D.There is no difference
The distinction is the whole point of star schema.
Why this answer
Facts = measurable events (sales amounts, clicks) with FKs to dimensions. Dimensions = the 'who/what/where/when' context (customer, product, date, region) used to slice/aggregate facts. The exam loves this distinction.
Correct answer: A · Last reviewed 2026-11-05
Official AWS references
Practice this interactively
Answer without seeing the solution first in the Analytics on Azure practice session.
Practice Analytics on Azure