Emma is working in a data warehouse and finds a finance fact table links to an organization dimension, which in turn links to a currency dimension that not linked to the fact table. What type of…

The correct answer is C. Snowflake. Since the dimension links to a dimension that isn't connected to the fact table, it must be a Snowflake, with a Star, all dimensions link directly to the fact table, Sun and Comet are not data warehouse design patterns.

Data Concepts and Environments

Question

Emma is working in a data warehouse and finds a finance fact table links to an organization dimension, which in turn links to a currency dimension that not linked to the fact table. What type of design pattern is the data warehouse using?

Options

AStar.
BSun.
CSnowflake.
DComet.

How the community answered

(32 responses)

A
16% (5)
B
6% (2)
C
75% (24)
D
3% (1)

Explanation

Since the dimension links to a dimension that isn't connected to the fact table, it must be a Snowflake, with a Star, all dimensions link directly to the fact table, Sun and Comet are not data warehouse design patterns.

Topics

#Data Warehouse Design#Snowflake Schema#Fact Tables#Dimension Tables

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice