Microsoft Exam MB-260 Topic 11 Question 44 Discussion

Actual exam question for Microsoft's MB-260 exam

Question #: 44
Topic #: 11

Your company uses Microsoft Dynamics 365 Customer Insights - Data as the Customer Data Platform.

The marketing team needs to know the total amount the customer has spent. The order lines are linked to a profile as part of the point-of-sale data source and through their loyalty ID.

Which function should you select in order to create this insight when creating a measure?

AIn the configuration area, choose MODE as the aggregation function.

BIn the configuration area, choose TOTAL as the aggregation function.

CIn the configuration area, choose SUM as the aggregation function. Select the order line table and add the amount field.

DIn the configuration area, choose AGGREGATE as the aggregation function. Select the order line table and add the amount field.

Show Suggested Answer

Suggested Answer: C

by Lashawnda at Oct 22, 2024, 05:20 AM

Limited Time Offer

25%

Off

Get Premium MB-260 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jovita

11 days ago

Whoa, hold up! I was about to pick MODE just to mess with the marketing team. But I guess C is the way to go. Bummer.

upvoted 0 times

...

Pura

12 days ago

This is a no-brainer. C is the only logical choice to get the total customer spend. Honestly, who even considers MODE for this?

upvoted 0 times

...

Valentin

15 days ago

Wait, why would anyone choose MODE? That's just plain weird. C is definitely the way to go here.

upvoted 0 times

Quentin

5 days ago

I agree, C is the best option for calculating the total amount spent by the customer.

upvoted 0 times

...

Magnolia

1 months ago

I was totally going to pick D, but now I see why C is the better option. Gotta love a good SUM function!

upvoted 0 times

...

1 months ago

I think C is the correct answer. SUM is the way to go to get the total amount spent by the customer.

upvoted 0 times

Tammy

2 days ago

User 4: Definitely, having the total amount spent by each customer can help in creating targeted marketing strategies.

upvoted 0 times

...

Buck

8 days ago

User 3: That makes sense. It's important for the marketing team to have accurate insights on customer spending.

upvoted 0 times

...

Lettie

16 days ago

User 2: I agree, selecting SUM as the aggregation function and adding the amount field from the order line table should give us the total amount spent.

upvoted 0 times

...

Magdalene

22 days ago

User 1: I think C is the correct answer. SUM is the way to go to get the total amount spent by the customer.

upvoted 0 times

...

Hailey

1 months ago

I think we should choose SUM as the aggregation function.

upvoted 0 times

...