Courseiva
Visualization and Reporting →mediumMultiple Choice

DA0-002 Visualization and Reporting Practice Question

A financial analyst wants to create a dashboard that shows the monthly profit and loss, highlighting how each component (revenue, cost of goods sold, operating expenses) contributes to the final net profit. Which chart type is most appropriate?

⚠ Common exam trap

DA0-002 often tests the confusion between charts that show composition (pie, stacked bar) and charts that show sequential contribution to a final value (waterfall), so candidates who see 'components contributing to net profit' and reach for a pie or stacked bar fall into the trap.

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

✓

Waterfall chart

A waterfall chart is purpose-built to show how an initial value is incrementally increased or decreased by a series of positive and negative contributors to arrive at a final total. For a P&L, it starts at revenue, subtracts COGS and operating expenses as downward steps, and lands on net profit — making each component's contribution visually explicit. This is exactly the 'bridge' or 'walk' visualization finance teams use for variance and P&L analysis.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    Pie chart

    Why it's wrong here

    A pie chart encodes parts of a single whole at one point in time, so it cannot display monthly progression or the arithmetic subtraction producing net profit. It fits showing a static composition, such as one month's expense breakdown by category, where proportions of a fixed total are the message.

  • ✗

    Stacked bar chart

    Why it's wrong here

    Stacked bars show composition of a total, not the positive and negative contributions that build net profit from revenue, COGS and expenses. Stacked bars suit part-to-whole comparisons such as sales by region within a quarter.

  • ✗

    Area chart

    Why it's wrong here

    An area chart plots cumulative magnitude over time, so stacked series obscure the individual revenue, COGS and expense contributions the analyst must isolate. It suits showing total volume trends, such as cumulative sales across regions, where the aggregate shape matters rather than each component's discrete effect on net profit.

  • ✓

    Waterfall chart

    Why this is correct

    A waterfall chart shows how sequentially added or subtracted components bridge an opening balance to a closing total, so revenue, cost of goods sold and operating expenses visibly build to net profit. This matches the requirement to highlight each component's contribution rather than just the final figure.

About these practice questions

One of 1,004 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 →

How Courseiva writes practice questions · Editorial policy

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.