What type of design...
 
Notifications
Clear all

What type of design pattern is the data warehouse using?

1 Posts
1 Users
0 Likes
163 Views
Randolph
(@soquirandolph)
Noble Member
Joined: 7 months ago
Posts: 363
Topic starter  

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?

  • A . Star.
  • B . Sun.
  • C . Snowflake.
  • D . Comet.

Show Answer Hide Answer

Suggested Answer: C

Explanation:

Correct answer

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.

   
Quote
Topic Tags
Share: