CompTIA DA0-001 Exam - Topic 5 Question 18 Discussion

Actual exam question for CompTIA's DA0-001 exam

Question #: 18
Topic #: 5

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?

AStar.

BSun.

CSnowflake.

DComet.

Show Suggested 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:

Submit Cancel

Avery

7 months ago

Really? I thought all dimensions had to connect directly to the fact table.

upvoted 0 times

...

Ashleigh

7 months ago

Pretty sure it's Snowflake since the currency isn't directly linked.

upvoted 0 times

...

Jina

7 months ago

Wait, isn't Comet a thing too?

upvoted 0 times

...

Krystal

7 months ago

I think it's a Star schema, not Snowflake.

upvoted 0 times

...

Rikki

7 months ago

Definitely a Snowflake design!

upvoted 0 times

...

Evelynn

8 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

8 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

8 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

8 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

8 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

8 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

8 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

8 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

...