DA0-002 · Question #103
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?
The correct answer is B. An error in SQL code. If an employee sales report consistently reflects sales only for the current month, the most likely cause is an error in the underlying SQL code that filters the data.
Question
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?
Options
- ALack of permissions
- BAn error in SQL code
- CReport refresh failure
- DConnectivity issues
How the community answered
(34 responses)- A18% (6)
- B71% (24)
- C3% (1)
- D9% (3)
Why each option
If an employee sales report consistently reflects sales only for the current month, the most likely cause is an error in the underlying SQL code that filters the data.
Lack of permissions would likely prevent the report from running entirely or accessing specific tables, not selectively limit data to the current month.
An error in SQL code, such as a WHERE clause filtering by a specific month or a date function only retrieving current month data, would directly cause the report to display only the current month's sales, despite other data existing in the database. This directly controls the data subset pulled for the report.
Report refresh failure would mean the data is completely outdated or not loading, not consistently showing only current month data.
Connectivity issues would prevent the report from accessing the data source at all, leading to errors or no data, rather than correctly displaying only current month data.
Concept tested: SQL query logic, data filtering errors
Source: https://learn.microsoft.com/en-us/sql/t-sql/queries/where-transact-sql
Topics
Community Discussion
No community discussion yet for this question.