DA0-002 Data Analysis Practice Question
A data analyst is building a dashboard that tracks daily active users. The source system records one event row per user session, and a user can have multiple sessions in a day. The analyst needs to display the count of unique users per day. Which approach produces the correct daily active user count?
⚠ Common exam trap
The trap here is treating the row grain of the source table as the unit of analysis, when the business question asks about distinct people rather than events.
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
✓
Count distinct user identifiers grouped by date
Daily active users is defined as the number of distinct users who take an action on a given day. Because the source grain is one row per session, the analyst must deduplicate users within each date before counting. A distinct count of the user identifier grouped by date performs exactly that deduplication and yields the correct metric, whereas counting rows or averaging sessions measures activity volume instead of reach.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Sum the maximum session count per user across all dates
Why it's wrong here
Taking a per-user maximum and summing across dates mixes users from different days into a single figure and can count the same user repeatedly. It produces a cumulative-style number that does not align with any single day's active-user count, so it cannot populate a daily unique-user metric.
- ✗
Average the number of session rows per user for each date
Why it's wrong here
Averaging sessions per user describes engagement intensity, not reach. A day with ten users each having one session and a day with two users each having five sessions could produce similar averages but very different active-user counts, so this calculation does not represent unique users.
- ✗
Count all session rows grouped by date
Why it's wrong here
Counting session rows measures sessions, not users, so a single user with five sessions inflates the metric by a factor of five. The dashboard would overstate engagement and mislead stakeholders about how many distinct people used the product, so this approach does not answer the unique-user question.
- ✓
Count distinct user identifiers grouped by date
Why this is correct
Applying a distinct count to the user identifier within each date collapses multiple sessions for the same user into one, producing the true number of unique users active that day. This directly matches the definition of daily active users and prevents session volume from distorting the metric.
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.