ExamTopics Logo
Mail Us[email protected]
Menu
Comptia Discussions
exam questions

Exam DA0-001 All Questions

View all questions & answers for the DA0-001 exam
Go to Exam

Exam DA0-001 topic 1 question 33 discussion

Actual exam question from CompTIA's DA0-001
Question #: 33
Topic #: 1
[All DA0-001 Questions]

Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?

  • A. Missing data
  • B. Duplicate data
  • C. Redundant data
  • D. Invalid data
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by CineFeX at Jan. 2, 2023, 8:22 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
vesen22
7 months, 2 weeks ago
Selected Answer: B
Duplicate data
upvoted 1 times
...
CineFeX
1 year, 5 months ago
B. A DISTINCT function is used to return unique values in a data set. It removes duplicates from the data set, so when a DISTINCT function is applied, the data cleansing issue of duplicate data will be fixed. Missing data, redundant data, and invalid data are not issues that will be fixed by applying a DISTINCT function. These issues can be addressed using other data cleansing techniques such as imputation for missing data, consolidation for redundant data, and validation for invalid data.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel