MB-910 Timestamp comparison Practice Question
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?
⚠ Common exam trap
The trap is that candidates may incorrectly focus on the `NOT EXISTS` subquery, thinking it's the cause of zero results, when the real issue is the timestamp direction. They might also confuse the meaning of '> 7 days ago' as 'older than 7 days' instead of 'newer than 7 days'.
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
✓
The timestamp condition is reversed; it should be CartAdd.Timestamp < 7 days ago to find older carts
The condition `CartAdd.Timestamp > 7 days ago` selects records where the cart addition occurred **less than** 7 days ago (i.e., within the last 7 days). To find customers who added items to the cart more than 7 days ago without purchase, the condition should be `CartAdd.Timestamp < 7 days ago` (older than 7 days). The segment returns no members because it is looking for recent cart additions instead of older ones. The `NOT EXISTS` subquery logic is actually correct for abandoned carts (checking that no purchase occurred after the cart addition), but the primary issue is the reversed timestamp comparison.
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.
- ✗
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.
Go deeper
Related to this question
About these practice questions
This MB-910 question is part of Courseiva's 941-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.