CompTIA Data+ (DA0-001) — Question 179

A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table. This structure is an example of a:

Answer options

• A. non-relational schema.
• B. galaxy schema.
• C. snowflake schema.
• D. star schema.

Correct answer: D

Explanation

The star schema is the correct answer because it features a central fact table surrounded by denormalized dimension tables, which is ideal for query performance. The galaxy schema involves multiple fact tables and is more complex, while the snowflake schema consists of normalized dimension tables and is not represented here. A non-relational schema does not apply to this structured setup.