Microsoft Exam DP-900 Topic 11 Question 80 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 80
Topic #: 11

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 Yan at May 01, 2024, 05:56 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Rusty

8 months ago

I went with 'fact' too. The unique key and numbers fit that definition.

upvoted 0 times

...

Bette

8 months ago

Exactly. Dimensions hold descriptive attributes. Facts deal with the numbers.

upvoted 0 times

...

Sol

9 months ago

Makes sense. Dimension tables are more for categories, right?

upvoted 0 times

...

Lino

9 months ago

I believe it's 'fact'. Fact tables aggregate numeric values based on unique keys.

upvoted 0 times

...

Ilene

9 months ago

Yeah, not sure if 'fact' is the right answer. What do you think?

upvoted 0 times

...

Clorinda

9 months ago

Did you get stuck on the data model question?

upvoted 0 times

...