DA0-002 Visualization and Reporting Practice Question
A data analyst is building a dashboard for a regional sales director who needs to monitor daily performance across 12 territories. The director wants to instantly see which territories are below target, with the ability to click a territory to view its individual store details. The analyst decides to use a bullet chart for each territory. Which design choice best supports the director's need for immediate exception identification and drill-down?
⚠ Common exam trap
The trap here is assuming that showing actual and target values on the same chart is sufficient for exception identification, when preattentive color encoding is needed for rapid scanning.
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
✓
Apply a conditional color rule that highlights bullet charts in red when actual sales fall below the target, and enable drill-through to a store-level detail page.
The director needs to instantly spot territories below target and then drill into store details. Conditional formatting on bullet charts uses color to preattentively flag exceptions, while drill-through provides the required detail. Together, these features meet both requirements without forcing the director to interpret each chart individually.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a stacked bar chart with actual and target values stacked on top of each other, and add a tooltip showing the variance.
Why it's wrong here
Stacking actual and target values misrepresents the comparison because the target is not an additive component of actual sales. The resulting bar height is meaningless for performance evaluation. A tooltip requires hovering, which does not provide the immediate visual exception identification the director needs across all territories.
- ✗
Replace the bullet charts with a single pie chart showing each territory's percentage of total sales.
Why it's wrong here
A pie chart shows part-to-whole composition, not performance against a target. It cannot indicate which territories are below target, and it does not support drill-down to store details. The director would lose the ability to see actual versus target at a glance, making exception identification difficult.
- ✗
Use a uniform color for all bullet charts and rely on the target marker position to indicate performance.
Why it's wrong here
A uniform color removes the preattentive cue that quickly separates below-target territories from those meeting goals. While the target marker shows performance, scanning 12 identical charts forces the director to read each one, slowing exception identification. Drill-down may still work, but the primary need for instant visual alert is compromised.
- ✓
Apply a conditional color rule that highlights bullet charts in red when actual sales fall below the target, and enable drill-through to a store-level detail page.
Why this is correct
Conditional coloring makes below-target territories immediately visible without reading each chart, and drill-through provides the requested store-level detail. This combination directly addresses both the need for instant exception identification and the ability to investigate a territory. The bullet chart itself shows actual versus target, and the color adds a preattentive alert.
Go deeper
Related to this question
About these practice questions
This DA0-002 question is part of Courseiva's 1,004-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 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.