DA0-001 · Question #6
Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?
The correct answer is D. Invalid data type. When a column that should contain only integers also contains character (string) values, this is an invalid data type issue. Each column in a dataset should have a consistent, appropriate data type. Mixing types - such as '123', 'N/A', and 'unknown' alongside numeric values…
Question
Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?
Options
- ADuplicate data
- BMissing data
- CData outliers
- DInvalid data type
How the community answered
(31 responses)- A3% (1)
- C3% (1)
- D94% (29)
Explanation
When a column that should contain only integers also contains character (string) values, this is an invalid data type issue. Each column in a dataset should have a consistent, appropriate data type. Mixing types - such as '123', 'N/A', and 'unknown' alongside numeric values - breaks type integrity and can cause errors in calculations and analysis. This is distinct from duplicate data (repeated records), missing data (null/empty values), or outliers (extreme but valid numeric values).
Topics
Community Discussion
No community discussion yet for this question.