TDWI CBIP Practice Questions - Certified Business Intelligence Professional Exam

A star schema differs from a snowflake schema primarily in that the star schema:

Keeps dimension tables denormalized in a single flat table per dimension Normalizes dimension tables into multiple related sub-tables Eliminates the central fact table entirely Stores only aggregated data and no atomic detail

Correct Answer:

Keeps dimension tables denormalized in a single flat table per dimension

Access more questions from this quiz

Continue to TDWI CBIP Practice Questions - Certified Business Intelligence Professional Exam for more practice questions and the full quiz experience.

Access More Questions