hardMultiple ChoiceObjective-mapped
MB-920 Practice Question: A Dynamics 365 Sales user runs a FetchXML query…
Exhibit
Refer to the exhibit.
```xml
<retrieveMultiple>
<entity name="account">
<filter type="and">
<condition attribute="address1_city" operator="eq" value="Seattle"/>
<condition attribute="revenue" operator="gt" value="1000000"/>
</filter>
<order attribute="name" descending="false"/>
</entity>
</retrieveMultiple>
```A Dynamics 365 Sales user runs a FetchXML query similar to the exhibit to retrieve accounts. The query returns fewer results than expected. The user expects to see accounts from Seattle with revenue over $1,000,000, but some accounts meeting these criteria are missing. What is the most likely cause?
⚠ Common exam trap
Watch out — candidates often assume 'over $1,000,000' naturally excludes the exact value, but the FetchXML operator 'gt' strictly excludes it, while 'ge' would include it—testing attention to operator semantics versus natural language interpretation.
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 revenue condition uses 'gt' instead of 'ge', so accounts with exactly $1,000,000 are excluded
The FetchXML query uses 'gt' (greater than) for the revenue condition, which excludes accounts with revenue exactly $1,000,000. The user expects accounts with revenue over $1,000,000, but 'gt' is strictly greater than, so accounts with revenue equal to $1,000,000 are omitted. Changing the operator to 'ge' (greater than or equal to) would include those accounts, resolving the discrepancy.
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 revenue condition uses 'gt' instead of 'ge', so accounts with exactly $1,000,000 are excluded
Why this is correct
Correct: 'gt' means greater than, so exactly $1,000,000 is not included.
- ✗
The filter type should be 'or' to include all Seattle accounts regardless of revenue
Why it's wrong here
Using 'or' would include accounts that meet either condition, but the user expects both conditions.
- ✗
The order attribute is incorrect, causing some records to be hidden
Why it's wrong here
Order only affects sorting, not filtering.
- ✗
The entity name is misspelled as 'account' instead of 'accounts'
Why it's wrong here
'account' is the correct entity name in Dynamics 365.
Visual reference
Go deeper
Related to this question
About these practice questions
One of 930 original MB-920 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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-920 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-920 exam.