nerdexam
CompTIA

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.

Data Acquisition and Preparation

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)
  • A
    18% (6)
  • B
    71% (24)
  • C
    3% (1)
  • D
    9% (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.

ALack of permissions

Lack of permissions would likely prevent the report from running entirely or accessing specific tables, not selectively limit data to the current month.

BAn error in SQL codeCorrect

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.

CReport refresh failure

Report refresh failure would mean the data is completely outdated or not loading, not consistently showing only current month data.

DConnectivity issues

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

#SQL errors#Data filtering#Report accuracy

Community Discussion

No community discussion yet for this question.

Full DA0-002 Practice