DA0-002 Visualization and Reporting Practice Question
Exhibit
Refer to the exhibit. Table Name: sales_data Columns: region, product, units_sold, price, date Query: SELECT region, SUM(units_sold * price) as revenue FROM sales_data GROUP BY region ORDER BY revenue DESC;
The exhibit shows a SQL query result intended for a bar chart of revenue by region. However, the chart shows only the top 10 regions, but the query returns all regions. What is the most likely cause?
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 visualization tool has a default limit on the number of categories displayed
The SQL query itself returns all regions because there is no LIMIT clause. However, the visualization tool has a built-in default limit on the number of categories displayed, such as top 10, which truncates the data in the chart. This is the most likely cause, making Option B correct. Options A, C, and D are incorrect: the GROUP BY clause is correctly specified, a WHERE clause is not required to get all regions, and the ORDER BY clause may be applied for sorting but the tool's limit overrides the full result set.
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 GROUP BY clause is incorrect
Why it's wrong here
GROUP BY region is correct for revenue by region.
- ✓
The visualization tool has a default limit on the number of categories displayed
Why this is correct
Many tools limit categories to avoid clutter unless configured otherwise.
- ✗
The query is missing a WHERE clause
Why it's wrong here
WHERE is not needed if all data is to be included.
- ✗
The ORDER BY clause is ignored in the chart
Why it's wrong here
ORDER BY does not affect the number of rows returned; it just orders them.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DA0-002 question from scratch — 986 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 by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.