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

5 months 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

5 months 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

5 months ago

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

upvoted 0 times

Douglass

4 months ago

Definitely, MODE wouldn't give an accurate total amount. C is the clear choice for this scenario.

upvoted 0 times

...

Bok

4 months ago

Yeah, selecting SUM as the aggregation function and adding the amount field from the order line table makes the most sense.

upvoted 0 times

...

Quentin

5 months ago

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

upvoted 0 times

...

Magnolia

5 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

...

Stanford

5 months ago

Hmm, I was considering B, but C makes more sense since we need to sum up the order line amounts. Good call, Gerald!

upvoted 0 times

Tyra

5 months ago

I think C is the most suitable function for creating the insight we need. Good thinking!

upvoted 0 times

...

Ashlyn

5 months ago

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

upvoted 0 times

...

Brandon

5 months ago

Thanks! I agree, C is the correct choice for summing up the order line amounts.

upvoted 0 times

...

Aracelis

6 months ago

I agree with Hailey, selecting SUM makes sense because we need to calculate the total amount spent by the customer.

upvoted 0 times

...

Gerald

6 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

4 months ago

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

upvoted 0 times

...

Buck

5 months ago

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

upvoted 0 times

...

Lettie

5 months 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

5 months 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

6 months ago

I think we should choose SUM as the aggregation function.

upvoted 0 times

...