DA0-002 Visualization and Reporting Practice Question
A data analyst receives a request from a sales manager for a one-time report on Q4 performance by product line. The report is not expected to be repeated. Which type of report should the analyst create?
⚠ Common exam trap
The trap is overthinking 'self-service' as the modern answer — candidates pick it because it sounds agile, but the question hinges on the one-time, non-recurring nature, which maps to ad hoc.
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
✓
Ad hoc report
An ad hoc report is a one-time, on-demand report created for a specific question and not scheduled or reused. The scenario explicitly states the report is not expected to be repeated, which is the defining characteristic of ad hoc reporting. Scheduled, operational, and self-service reports all imply recurring or ongoing use.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Scheduled report
Why it's wrong here
A scheduled report runs automatically at set intervals, which contradicts the requirement that the report is not expected to be repeated. It is tempting because scheduling is standard for recurring performance reporting, but with no repeat occurrence, a one-off ad hoc report is required instead.
- ✗
Operational report
Why it's wrong here
Operational reports support day-to-day transactional monitoring, not a retrospective Q4 analysis by product line. It is tempting because operational reporting is a recognised report category, but its purpose is ongoing activity tracking, whereas a one-time historical summary calls for an ad hoc report.
- ✓
Ad hoc report
Why this is correct
An ad hoc report is generated once for a specific, non-recurring request, matching the Q4 product-line analysis that will not be repeated. Recurring or scheduled reporting types would impose unnecessary ongoing effort for a one-time need.
- ✗
Self-service report
Why it's wrong here
Self-service reporting lets business users build their own views via BI tooling, which does not deliver a defined one-time deliverable the analyst must produce. It is tempting because ad hoc requests are user-driven, but self-service suits recurring exploratory access, not a single commissioned Q4 report.
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.