Free CompTIA DA0-002 Actual Exam Questions - Question 1 Discussion
[Data Analysis]
A data analyst learns that a report detailing employee sales is reflecting sales only for the current month. Which of the following is the most likely cause?
Good point on permissions not usually filtering by date. I think C could be ruled out because a refresh failure might just show old data, not restrict to current month only. B sounds right here.
D imo, connectivity issues could stop full data loads, limiting results to current month.
This one feels like a permissions issue too. If the analyst only has access to current month data, the report would naturally limit sales info to that range, so A makes sense. If it was a SQL error, you’d expect either no data or an error message, not just limited data.
It’s B for me too because if the SQL query has a WHERE clause filtering dates to the current month, that would explain why only current sales show up, regardless of refresh or permissions.
Maybe B, the SQL code might have a filter restricting data to the current month.
It’s C because if the report isn’t refreshing properly, it might only show outdated or partial data like just the current month, not a full range.
B imo, report refresh failure seems less likely than a code error limiting data.