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.


Correct Option: D

Find more quizzes: