Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-900 Topic 9 Question 82 Discussion

Actual exam question for Microsoft's DP-900 exam
Question #: 82
Topic #: 9
[All DP-900 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

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
6 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
6 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
6 months ago
Yes, you're right. Dimension tables are used for that purpose.
upvoted 0 times
...
Phillip
6 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
...
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77