DA0-002 Data Acquisition and Preparation Practice Question
In a sales database, an analyst needs to retrieve all orders where the order amount is between $100 and $500. Which WHERE clause should be used?
⚠ Common exam trap
DA0-002 often tests the inclusivity of BETWEEN, and candidates may incorrectly choose strict inequalities or the IN operator. The trap is forgetting that BETWEEN includes the boundary values.
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
✓
WHERE amount BETWEEN 100 AND 500
The BETWEEN operator is inclusive of the boundary values, so WHERE amount BETWEEN 100 AND 500 will return all orders where the amount is greater than or equal to 100 and less than or equal to 500. This is the most concise and correct way to express the range.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
WHERE amount IN (100, 500)
Why it's wrong here
IN matches only the two listed values, 100 and 500, returning no orders with amounts in between. It is tempting because the numbers appear in the stem. The correct clause uses BETWEEN 100 AND 500, which selects every amount across the continuous interval.
- ✗
WHERE amount >= 100 AND amount <= 500
Why it's wrong here
This is also correct but not the best answer; BETWEEN is more concise.
- ✓
WHERE amount BETWEEN 100 AND 500
Why this is correct
BETWEEN is inclusive on both bounds, returning rows where amount equals 100 or 500 as well as those between. This satisfies the stem's requirement to capture orders from $100 to $500, whereas exclusive comparisons would silently omit boundary orders worth exactly $100 or $500.
- ✗
WHERE amount > 100 AND amount < 500
Why it's wrong here
This excludes 100 and 500, not matching the requirement.
About these practice questions
Courseiva writes every DA0-002 question from scratch — 1,004 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official CompTIA exam blueprint
This DA0-002 practice question is part of Courseiva's free CompTIA 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 DA0-002 exam.