Multiple choice technology

What is star schema?

  1. A single fact table with one Dimension

  2. A single fact table with N number of Dimension

  3. A single fact table with two Dimension

  4. Any dimensions with extended dimensions
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A star schema consists of a single central fact table connected to multiple dimension tables, forming a star-like structure when visualized. The fact table stores quantitative data, while dimension tables contain descriptive attributes. This differs from snowflake schemas where dimensions are normalized.

Keep practicing — related questions