DA0-002 Visualization and Reporting Practice Question
A finance department wants to compare actual expenses against budgeted amounts for each of 10 departments over the past 12 months. They need to show the variance (over/under budget) as well as the trend of expenses over time. The data includes monthly actual and budget figures for each department. The audience is the CFO who needs a quick overview. Which visualization approach should be used?
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
✓
A dual-axis chart with bars for actual and budget by month for each department, and a line for variance
A dual-axis chart with bars for actual and budget by month for each department, and a line for variance, allows the CFO to quickly compare actual vs budget figures and see the trend of variance over time. Option B (waterfall chart) is better suited for cumulative changes over time, not month-by-month comparisons. Option C (table with conditional formatting) does not provide a quick visual overview of trends. Option D (stacked bar chart) makes it difficult to compare actual vs budget across departments and months, and obscures individual department trends.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
A dual-axis chart with bars for actual and budget by month for each department, and a line for variance
Why this is correct
Dual-axis allows direct comparison of actual vs budget over time, and the line highlights variance trend.
- ✗
A waterfall chart showing cumulative variance over the year
Why it's wrong here
Waterfall shows cumulative effect, not monthly trends or individual department comparisons.
- ✗
A table with conditional formatting to highlight over-budget cells
Why it's wrong here
Tables are not ideal for quick visual trends; they require close reading.
- ✗
Stacked bar chart with one bar per month, segments showing each department's actual and budget
Why it's wrong here
Too many segments per bar make it hard to compare budgets vs actuals across months.
Go deeper
Related to this question
About these practice questions
One of 986 original DA0-002 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 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.