A salesperson who is prospecting potential clients collected the following data: Which of the following is an issue with this data?

The correct answer is B. Invalid data. Looking at the table, Jules Martin’s phone number is listed as (3OO)563-3435, where the area code contains the letter "O" instead of the digit "0." This is an example of invalid data, since an area code should consist only of numbers. There are no duplicate rows, no missing…

Data Governance, Quality, and Controls

Question

A salesperson who is prospecting potential clients collected the following data:

Which of the following is an issue with this data?

Exhibit

Options

ADuplicate data
BInvalid data
CMissing value
DRedundant data

How the community answered

(50 responses)

A
2% (1)
B
86% (43)
C
4% (2)
D
8% (4)

Explanation

Looking at the table, Jules Martin’s phone number is listed as (3OO)563-3435, where the area code contains the letter "O" instead of the digit "0." This is an example of invalid data, since an area code should consist only of numbers. There are no duplicate rows, no missing values, and columns are not redundant.

Topics

#Data quality#Data issues#Invalid data#Data validation

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice