Multiple choice technology enterprise content management

What does a star schema database structure typically consist of?

  1. De-normalized hierarchy of dimension tables and fact tables.

  2. Normalized dimension tables and detailed fact tables.

  3. Normalized dimension tables and summarized fact tables.

  4. De-normalized dimension tables and fact tables.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A classic star schema consists of a centralized fact table containing quantitative metrics, surrounded by de-normalized dimension tables that provide descriptive attributes about the business. De-normalizing the dimensions simplifies queries and improves reporting performance.

Keep practicing — related questions