ExamGecko
Question list
Search
Search

List of questions

Search

Question 110 - DA0-001 discussion

Report
Export

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.
Answers
A.
Star.
B.
Sun.
Answers
B.
Sun.
C.
Snowflake.
Answers
C.
Snowflake.
D.
Comet.
Answers
D.
Comet.
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.

asked 02/10/2024
Tarun Sharma
45 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first