CompTIA Data+ (DA0-001) — Question 72

A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:

Answer options

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

Correct answer: D

Explanation

The correct answer is D, snowflake schema, which is characterized by its normalized tables for dimensions. The other options do not accurately describe this structure: A, transactional schema, refers to operational systems; B, star schema, features denormalized dimensions; and C, non-relational schema, indicates a lack of relational database structure.