A data set for sales per month includes the following data: Which of the following cleaning and profiling methods should be applied to the data set?

The correct answer is D. Data type validation. In the "Sales (%)" column, most entries are integers (e.g., 55, 36, 70), but Feb shows '60'-a value surrounded by quotation marks, meaning it is stored as a text (string) rather than a number. This is a data type issue. Data type validation ensures that all values in a column…

Data Governance, Quality, and Controls

Question

A data set for sales per month includes the following data:

Which of the following cleaning and profiling methods should be applied to the data set?

Exhibit

Options

AData outliers
BInvalid data
CDuplicate data
DData type validation

How the community answered

(28 responses)

A
14% (4)
B
7% (2)
C
4% (1)
D
75% (21)

Explanation

In the "Sales (%)" column, most entries are integers (e.g., 55, 36, 70), but Feb shows '60'-a value surrounded by quotation marks, meaning it is stored as a text (string) rather than a number. This is a data type issue. Data type validation ensures that all values in a column have the correct type (in this case, numerical values in "Sales (%)"). Failing to validate data types can cause errors in calculations or

Topics

#Data cleaning#Data profiling#Data quality#Data type validation

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice