The answer is customers with total purchases greater than 500 since 2024. This KQL query first filters the dataset to include only purchase records from the year 2024 onward, then uses a summarize operator to group those records by customer and aggregate their total purchase amounts, and finally applies a where clause to retain only customers whose summed purchases exceed 500. On the Microsoft Dynamics 365 Fundamentals CRM MB-910 exam, this tests your ability to interpret KQL queries for customer purchase data, a skill often assessed in scenario-based questions about sales analytics or customer segmentation. A common trap is misreading the date filter as “before 2024” or forgetting that the sum is calculated per customer, not across all records. To remember the flow, think of it as a funnel: filter by time, group by customer, sum the amounts, then filter by threshold.
MB-910 Describe Dynamics 365 Customer Insights Practice Question
This MB-910 practice question tests your understanding of describe dynamics 365 customer insights. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
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?
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
A
Customers with total purchases greater than 500 since 2024
Correct: The query filters from 2024, sums amounts, and filters for total > 500.
B
Average purchase amounts for each customer since 2024
Why wrong: Wrong: The query uses sum, not average.
C
Customers with total purchases greater than 500 in 2023
Why wrong: Wrong: The query uses datetime(2024-01-01), not 2023.
D
Customers with total purchases less than 500 since 2024
Why wrong: Wrong: The condition is TotalPurchases > 500, not less than.
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.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
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.
Related concept
Read the scenario before looking for a memorised answer.
✗
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.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates may 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.
Detailed technical explanation
How to think about this question
In KQL, the `summarize` operator with `sum()` computes the total per group, and the `where` clause after `summarize` filters aggregated results. The timestamp filter `>= datetime(2024-01-01)` ensures only records from 2024 onward are included, which is a common pattern for year-to-date analysis in Dynamics 365 Customer Insights data exports.
KKey Concepts to Remember
Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Got this wrong? Here's your next step.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Describe Dynamics 365 Customer Insights — This question tests Describe Dynamics 365 Customer Insights — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: 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.
What should I do if I get this MB-910 question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
This MB-910 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the MB-910 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.