nerdexam
CompTIA

DA0-001 · Question #240

Given the following data set: Which of the following steps would be MOST appropriate to cleanse the data set?

The correct answer is A. Remove duplicate data. When cleansing a data set, removing duplicate data is a fundamental and often primary step to ensure accuracy and prevent skewed analysis. Duplicates can inflate counts or distort statistical measures, making their removal crucial for data integrity.

Data Governance, Quality, and Controls

Question

Given the following data set:

Which of the following steps would be MOST appropriate to cleanse the data set?

Exhibit

DA0-001 question #240 exhibit

Options

  • ARemove duplicate data.
  • BRemove outliers.
  • CVerify the data.
  • DAdd missing values.

How the community answered

(51 responses)
  • A
    86% (44)
  • B
    2% (1)
  • C
    4% (2)
  • D
    8% (4)

Why each option

When cleansing a data set, removing duplicate data is a fundamental and often primary step to ensure accuracy and prevent skewed analysis. Duplicates can inflate counts or distort statistical measures, making their removal crucial for data integrity.

ARemove duplicate data.Correct

Removing duplicate data is a critical initial step in data cleansing as it ensures that each record is unique, preventing overcounting or misrepresentation in analyses. Duplicate entries can arise from various sources and must be addressed to maintain data quality and accuracy.

BRemove outliers.

Removing outliers is a step in data preprocessing often done after initial cleansing, focusing on extreme values rather than fundamental record uniqueness.

CVerify the data.

Verifying the data is a broader process of checking accuracy against sources, not a specific cleansing action for an initial pass.

DAdd missing values.

Adding missing values, also known as imputation, is a technique to handle incomplete data, but it typically follows the identification and removal of duplicate records.

Concept tested: Data cleansing - duplicate removal

Source: https://learn.microsoft.com/en-us/training/modules/clean-data-power-bi/3-explore-clean-data

Topics

#Data Cleansing#Data Quality#Duplicate Data#Data Preparation

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice