Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

CompTIA Exam DA0-001 Topic 5 Question 18 Discussion

Actual exam question for CompTIA's DA0-001 exam
Question #: 18
Topic #: 5
[All DA0-001 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: C

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.


Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel