DA0-002 Visualization and Reporting Practice Question
A data analyst frequently receives ad hoc requests for the same type of analysis. Which TWO approaches could reduce the number of ad hoc requests?
⚠ Common exam trap
DA0-002 often tests the difference between reactive and proactive approaches, causing candidates to choose options that do not actually reduce request volume (like increasing data freshness or security) instead of automation and self-service.
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
✓
Create a scheduled report that covers the common analysis
Option B is correct because a scheduled report that covers the common analysis proactively delivers the recurring results the analyst keeps being asked for, eliminating the need for users to submit one-off requests each time. Option E is correct because a self-service BI tool lets business users build and run their own reports against governed data, shifting routine ad hoc demand away from the analyst. Option A is not correct because increasing data freshness to real-time addresses latency, not the volume of repetitive requests. Option C is not correct because adding security controls does not reduce how often users ask for the same analysis. Option D is not correct because ignoring requests is unprofessional and does nothing to eliminate the underlying recurring demand.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Increase data freshness to real-time
Why it's wrong here
Real-time freshness changes how current the data is, not how often the same analysis is requested; the recurring demand persists. It is tempting because latency is a common complaint, and streaming ingestion would be correct where decisions depend on sub-minute data, but here the requirement is eliminating repeat requests through reusable reporting.
- ✓
Create a scheduled report that covers the common analysis
Why this is correct
A scheduled report delivers the recurring analysis automatically at set intervals, so requesters self-serve instead of raising tickets. This satisfies the goal of reducing repeated ad hoc requests by converting a predictable, recurring need into a standing deliverable.
- ✗
Add more security to the data
Why it's wrong here
Restricting data access does not reduce demand; analysts still receive the same requests, merely with narrower visibility. It tempts as a governance control, which is its actual purpose. Reducing ad hoc volume comes from publishing reusable dashboards or self-service reports that requesters can consult directly.
- ✗
Ignore the requests until they become urgent
Why it's wrong here
Ignoring requests does not reduce their volume; it simply delays delivery and damages stakeholder trust, leaving the underlying recurring need unaddressed. It is tempting as a triage tactic when capacity is exhausted, but the correct approach is to build a reusable self-service report or dashboard that answers the repeated question directly.
- ✓
Encourage users to create their own reports using a self-service BI tool
Why this is correct
Self-service BI lets business users build and refresh their own dashboards against governed datasets, removing their dependence on the analytics team for repeatable questions. This directly cuts the recurring ad hoc requests described in the stem, since users answer the same analysis themselves.
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.