Which one of the following is a common data warehouse schema?

The correct answer is A. Snowflake. The two most common schemas used in data warehouses are the Star Schema and the Snowflake Schema. The Snowflake Schema is an extension of the Star Schema where dimension tables are normalized into multiple related tables, resembling the shape of a snowflake. Options B (Square)…

Data Concepts and Environments

Question

Options

ASnowflake.
BSquare.
CSpiral.
DSphere.

How the community answered

(50 responses)

A
92% (46)
B
2% (1)
C
2% (1)
D
4% (2)

Explanation

The two most common schemas used in data warehouses are the Star Schema and the Snowflake Schema. The Snowflake Schema is an extension of the Star Schema where dimension tables are normalized into multiple related tables, resembling the shape of a snowflake. Options B (Square), C (Spiral), and D (Sphere) are not real data warehouse schemas - they are distractors. Understanding these schemas is foundational to data warehousing and dimensional modeling.

Topics

#Data Warehouse#Schema#Snowflake Schema#Data Modeling

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice