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
An incorrect GROUP BY would produce wrong aggregation granularity, such as duplicate or mis-grouped region rows, not a truncated ten-row result. The stem reports the query returns all regions correctly aggregated. GROUP BY is correct when revenue must be summed per region.
- ✓
The visualization tool has a default limit on the number of categories displayed
Why this is correct
A default category cap in the visualisation tool truncates the axis to the first ten regions, leaving the remaining rows unrendered despite the query returning them. This satisfies the stem's constraint that the chart shows only the top 10 regions while the underlying SQL result contains all regions, so the query itself is not at fault.
- ✗
The query is missing a WHERE clause
Why it's wrong here
A WHERE clause filters rows by condition, such as restricting to specific regions; it cannot cap output at ten rows. The stem already states the query returns every region, so filtering is not the missing element. WHERE would be correct when excluding irrelevant regions from the result set.
- ✗
The ORDER BY clause is ignored in the chart
Why it's wrong here
ORDER BY only sequences rows; it never reduces their count, so the chart receiving all regions would still plot all of them. The stem shows the query returns every region. ORDER BY would be the right choice when the chart must display regions in a defined rank sequence.
Go deeper
Related to this question
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 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.