Microsoft Exam DP-900 Topic 9 Question 82 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 82
Topic #: 9

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 Tamie at May 20, 2024, 06:39 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Carmen

6 months ago

Fact table, no doubt about it. I've got that one burned into my brain from all the data modeling classes.

upvoted 0 times

...

Carolynn

6 months ago

Haha, I bet the answer is 'All of the above'. Those tricky exam writers love to mess with us!

upvoted 0 times

Kati

5 months ago

C) fact

upvoted 0 times

...

Amos

5 months ago

B) dimension

upvoted 0 times

...

Reuben

5 months ago

A) bridge

upvoted 0 times

...

Edward

6 months ago

Hmm, I'm pretty sure it's the bridge table. Isn't that the one that connects the fact and dimension tables together?

upvoted 0 times

Nan

5 months ago

You might be right, the bridge table does connect the fact and dimension tables together.

upvoted 0 times

...

Nina

5 months ago

No, I'm pretty sure it's the dimension table. It represents the entities with unique key values.

upvoted 0 times

...

Kaitlyn

6 months ago

I think it's actually the fact table. It contains the aggregated numeric values.

upvoted 0 times

...

Rhea

6 months ago

Gotta be the dimension table. Those are the entities we use to slice and dice the data, aren't they?

upvoted 0 times

Malcom

5 months ago

Exactly, dimension tables help us analyze the data from different perspectives.

upvoted 0 times

...

Cristy

5 months ago

Yes, you're right. Dimension tables are used for that purpose.

upvoted 0 times

...

Phillip

5 months ago

Dimension tables are essential for organizing data in an analytical model.

upvoted 0 times

...

Denise

6 months ago

I agree, dimension tables help us organize data for analysis.

upvoted 0 times

...

Glennis

6 months ago

Yes, you're right. Dimension tables are used for grouping and filtering data.

upvoted 0 times

...

Paola

6 months ago

Exactly, dimension tables help us analyze data from different perspectives.

upvoted 0 times

...

Casie

6 months ago

Yes, you're right. Dimension tables are used for that purpose.

upvoted 0 times

...

Theodora

7 months ago

I think it's definitely the fact table. That's where all the numeric data is stored, right?

upvoted 0 times

Reita

6 months ago

That's right. The fact table contains entities that are used to aggregate numeric values.

upvoted 0 times

...

Chuck

6 months ago

Yes, you are correct. The fact table is used to store numeric data for aggregation.

upvoted 0 times

...