Microsoft Exam DP-900 Topic 4 Question 74 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 74
Topic #: 4

In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?

Abridge

Bdimension

Cfact

Show Suggested Answer

Suggested Answer: C

by Heike at Jan 28, 2024, 07:39 PM

Limited Time Offer

25%

Off

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Hector

8 months ago

Hmm, I was a little unsure at first, but I think you guys have convinced me. Fact tables it is. Though I have to say, I'm still trying to wrap my head around the difference between bridge and dimension tables.

upvoted 0 times

...

Elenor

8 months ago

Yup, no doubt about it. Fact tables are the workhorses of an analytical data model. They're where the real action happens in terms of crunching the numbers.

upvoted 0 times

...

Nieves

8 months ago

I agree, the fact table is definitely the correct answer here. The key characteristic of a fact table is that it contains the measurable, quantitative data that we want to analyze.

upvoted 0 times

...

8 months ago

I agree, the fact table is used to store numeric values for analysis.

upvoted 0 times

...