CompTIA Data+ (DA0-001) — Question 116

Which of the following database schemas features normalized dimension tables?

Answer options

• A. Flat
• B. Snowflake
• C. Hierarchical
• D. Star

Correct answer: B

Explanation

The Snowflake schema is characterized by its normalized dimension tables, which helps reduce data redundancy and improve data integrity. In contrast, the Flat schema lacks normalization, while the Hierarchical and Star schemas also do not emphasize normalization in their dimension tables.