Given the image below: Which of the following data schemas is portrayed?

The correct answer is D. Star. A star schema features a central fact table directly connected to multiple denormalized dimension tables, forming a star-like shape. It is the most common schema used in data warehousing and OLAP environments because it optimizes query performance. A snowflake schema differs by…

Data Concepts and Environments

Question

Given the image below:

Which of the following data schemas is portrayed?

Exhibit

Options

ANon-relational
BGalaxy
CSnowflake
DStar

How the community answered

(62 responses)

A
2% (1)
B
2% (1)
C
6% (4)
D
90% (56)

Explanation

A star schema features a central fact table directly connected to multiple denormalized dimension tables, forming a star-like shape. It is the most common schema used in data warehousing and OLAP environments because it optimizes query performance. A snowflake schema differs by normalizing dimension tables into sub-dimensions (creating a more complex, branching structure). A galaxy schema contains multiple fact tables sharing dimension tables. A non-relational schema has no tables at all. The image described (central table with radiating dimension tables) is the hallmark of a star schema.

Topics

#Data schema#Star schema#Dimensional modeling

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice