Describe Dynamics 365 Customer Insights →mediumMultiple ChoiceObjective-mapped

MB-910 Describe Dynamics 365 Customer Insights Practice Question

Exhibit

Refer to the exhibit. The following is a portion of a KQL query used in Customer Insights:

CustomerInsights
| where Timestamp >= datetime(2024-01-01)
| summarize TotalPurchases = sum(Amount) by CustomerId
| where TotalPurchases > 500

You are analyzing customer purchase data. What does this KQL query return?

⚠ Common exam trap

Watch out — candidates often confuse the aggregation function (sum vs. avg) or misread the date filter as 'in 2023' instead of 'since 2024', leading them to select B or C.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Customers with total purchases greater than 500 since 2024

The KQL query filters customer purchase data to include only records from the year 2024 onward, then groups by customer and sums their purchase amounts, finally returning only those customers whose total purchases exceed 500. This matches option A exactly.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✓
Customers with total purchases greater than 500 since 2024
Why this is correct
Correct: The query filters from 2024, sums amounts, and filters for total > 500.
✗
Average purchase amounts for each customer since 2024
Why it's wrong here
Wrong: The query uses sum, not average.
✗
Customers with total purchases greater than 500 in 2023
Why it's wrong here
Wrong: The query uses datetime(2024-01-01), not 2023.
✗
Customers with total purchases less than 500 since 2024
Why it's wrong here
Wrong: The condition is TotalPurchases > 500, not less than.

Go deeper

MB-910 Describe Dynamics 365 Customer Insights Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question