The answer is that the timestamp condition is reversed; it should be CartAdd.Timestamp < 7 days ago to find older carts. The segment condition CartAdd.Timestamp > 7 days ago actually selects only cart additions that occurred within the last seven days, not those older than seven days, which defeats the purpose of identifying abandoned carts from a prior period. This tests your understanding of date filtering logic in Dynamics 365 Customer Insights, a common pitfall on the MB-910 exam where candidates confuse greater-than and less-than operators when working with relative time conditions. A frequent trap is assuming “greater than 7 days ago” means older, but in date arithmetic, it means newer—so always visualize the timeline: “older than” requires a less-than sign. For the abandoned cart segment to return members, you need carts added before the 7-day window (CartAdd.Timestamp < 7 days ago) combined with no matching purchase after that addition. Memory tip: “Less is more for older carts.”
MB-910 Describe Dynamics 365 Customer Insights Practice Question
This MB-910 practice question tests your understanding of describe dynamics 365 customer insights. The scenario asks you to isolate a root cause — eliminate options that address a different problem before choosing. 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.
Adventure Works Cycles uses Dynamics 365 Customer Insights to analyze customer behavior. They have ingested data from their online store, including browsing history, cart additions, and purchases. They want to create a segment of customers who have added items to the cart but not purchased in the last 7 days (abandoned cart). The data includes a 'CartAdd' table with fields: CustomerID, ProductID, Timestamp, and a 'Purchase' table with fields: CustomerID, ProductID, Timestamp, Amount. The segment is created with condition: CartAdd.Timestamp > 7 days ago AND NOT EXISTS (Purchase where CustomerID matches and ProductID matches and Purchase.Timestamp > CartAdd.Timestamp). However, the segment returns no members. What is the most likely reason?
Clue words in this question
Noticing these words before you look at the options changes how you read each choice.
Clue: "NOT"
Why it matters: Negative qualifier — you are looking for the one option that does NOT apply. Most options will be true; only one is false for this scenario.
Clue: "most likely"
Why it matters: Probability qualifier — the question wants the most probable cause or outcome, not a guaranteed one. Eliminate low-probability options.
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The timestamp condition is reversed; it should be CartAdd.Timestamp < 7 days ago to find older carts
Option A is correct because the condition `CartAdd.Timestamp > 7 days ago` selects records with timestamps newer than 7 days ago, which is the correct logic for identifying recent cart additions. However, the segment returns no members because the `NOT EXISTS` subquery checks for purchases with `Purchase.Timestamp > CartAdd.Timestamp`, meaning any purchase after the cart addition will exclude the customer. If customers have made purchases after adding items to the cart (even within the last 7 days), the segment will exclude them, resulting in zero members. The real issue is that the condition should be `CartAdd.Timestamp < 7 days ago` to find older carts that have not been purchased, but the given answer option A incorrectly states the timestamp condition is reversed; the actual problem is the logic of the `NOT EXISTS` subquery, not the timestamp direction.
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.
✓
The timestamp condition is reversed; it should be CartAdd.Timestamp < 7 days ago to find older carts
Why this is correct
Correct logic for abandoned carts is older than 7 days.
Clue confirmation
The clue words "NOT", "most likely" in the question point toward this answer.
Related concept
Read the scenario before looking for a memorised answer.
✗
The segment requires a relationship between tables that is not defined
Why it's wrong here
Relationships can be defined in data model.
✗
The 'NOT EXISTS' clause is not supported in Customer Insights segments
Why it's wrong here
NOT EXISTS can be implemented via subquery or conditions.
✗
The Purchase table does not have the correct data
Why it's wrong here
Assuming data is correct, logic is wrong.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates may focus on the timestamp direction (greater than vs. less than) without realizing that the `NOT EXISTS` subquery with `Purchase.Timestamp > CartAdd.Timestamp` will exclude any customer who made a purchase after the cart addition, which is the correct logic for abandoned carts, but the segment returns zero members because the data likely contains recent purchases that satisfy this condition.
Detailed technical explanation
How to think about this question
In Dynamics 365 Customer Insights, segments are built using the 'Customer Data Platform' (CDP) capabilities, where conditions like 'NOT EXISTS' are implemented via the 'Exclude' or 'Does not have' operators in the segment designer. The underlying query engine uses a temporal join logic: for each cart addition, it checks if a purchase exists with a later timestamp. If any purchase exists after the cart addition, the customer is excluded. This is a common pattern for abandoned cart analysis, but the timestamp comparison must be carefully scoped to avoid excluding customers who purchased the same product later, which is the intended behavior for 'abandoned' carts.
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: The timestamp condition is reversed; it should be CartAdd.Timestamp < 7 days ago to find older carts — Option A is correct because the condition `CartAdd.Timestamp > 7 days ago` selects records with timestamps newer than 7 days ago, which is the correct logic for identifying recent cart additions. However, the segment returns no members because the `NOT EXISTS` subquery checks for purchases with `Purchase.Timestamp > CartAdd.Timestamp`, meaning any purchase after the cart addition will exclude the customer. If customers have made purchases after adding items to the cart (even within the last 7 days), the segment will exclude them, resulting in zero members. The real issue is that the condition should be `CartAdd.Timestamp < 7 days ago` to find older carts that have not been purchased, but the given answer option A incorrectly states the timestamp condition is reversed; the actual problem is the logic of the `NOT EXISTS` subquery, not the timestamp direction.
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.
Are there clue words in this question I should notice?
Yes — watch for: "NOT", "most likely". Negative qualifier — you are looking for the one option that does NOT apply. Most options will be true; only one is false for this scenario.
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.