Multiple choice technology

Star schema

  1. One central Fact table surrounded by the dimensions.

  2. One central dimension table surrounded by the fact tables.

  3. One dimension table corresponding to Fact table.

  4. One Fact table corresponding to Fact table.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A star schema consists of a single central fact table containing quantitative and foreign key data, surrounded by multiple dimension tables that provide descriptive context. The name 'star' comes from the visual resemblance to a star when the schema is diagrammed, with the fact table at the center and dimension tables radiating outward like points.

Keep practicing — related questions