Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

CompTIA DA0-001 Exam - Topic 5 Question 18 Discussion

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

CompTIA DA0-001 Exam - 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.


by Izetta at May 30, 2023, 09:58 AM

Limited Time Offer

25%

Off

Get Premium DA0-001 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Avery
8 months ago
Really? I thought all dimensions had to connect directly to the fact table.
upvoted 0 times
...
Ashleigh
8 months ago
Pretty sure it's Snowflake since the currency isn't directly linked.
upvoted 0 times
...
Jina
9 months ago
Wait, isn't Comet a thing too?
upvoted 0 times
...
Krystal
9 months ago
I think it's a Star schema, not Snowflake.
upvoted 0 times
...
Rikki
9 months ago
Definitely a Snowflake design!
upvoted 0 times
...
Evelynn
9 months ago
I feel like I might be mixing up the terms, but I thought a comet schema involved multiple fact tables. This doesn't seem to fit that, so maybe it's snowflake?
upvoted 0 times
...
Yolando
9 months ago
This question reminds me of a practice one we did on snowflake schemas. I think the organization dimension linking to currency suggests a snowflake design.
upvoted 0 times
...
Clorinda
9 months ago
I'm not entirely sure, but I think a star schema has all dimensions directly linked to the fact table. Since the currency dimension isn't, it might not be that.
upvoted 0 times
...
Tanja
9 months ago
I remember studying the snowflake schema, where dimensions can be normalized. This seems like it could be that since the currency dimension isn't directly linked to the fact table.
upvoted 0 times
...
Jacquelyne
9 months ago
Hmm, this one seems straightforward. I think the answer is B - Integrity, since ensuring correct data input is about maintaining the accuracy and reliability of the information.
upvoted 0 times
...
Evangelina
9 months ago
This seems like a straightforward question about analyzing the costs of running a business. I think I'd approach it by focusing on the specific services offered and trying to break down the costs associated with each one.
upvoted 0 times
...
Cassi
9 months ago
Okay, I know Bluetooth uses the 2.4-2.5 GHz band, but I'm not sure which IEEE specification it uses. I'll have to think this through carefully.
upvoted 0 times
...
Lamar
10 months ago
Hmm, I'm a bit unsure about this one. I know ISO/IEC 20000 is related to IT service management, but I'm not entirely clear on the specific use cases. I'll have to think this through carefully.
upvoted 0 times
...

Save Cancel