nerdexam
CompTIA

DA0-001 · Question #383

An analyst needs to join two data sets that compare vehicle weights. One data set is in pounds, and the other has various units of measure. Which of the following should the analyst do first to the…

The correct answer is D. Normalize. Before joining two datasets with different units of measure, the analyst must normalize (D) the data - converting all vehicle weight values to a single, consistent unit (e.g., all pounds or all kilograms). Without normalization, comparisons across the joined dataset would be…

Data Analysis

Question

An analyst needs to join two data sets that compare vehicle weights. One data set is in pounds, and the other has various units of measure. Which of the following should the analyst do first to the data prior to any type of join?

Options

  • ABlend
  • BReduce
  • CConcatenate
  • DNormalize

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    8% (2)
  • D
    88% (21)

Explanation

Before joining two datasets with different units of measure, the analyst must normalize (D) the data - converting all vehicle weight values to a single, consistent unit (e.g., all pounds or all kilograms). Without normalization, comparisons across the joined dataset would be meaningless or misleading. Blending (A) combines data sources without standardizing. Reducing (B) decreases data volume. Concatenating (C) appends datasets end-to-end. None of those address the unit inconsistency problem.

Topics

#Data preparation#Data cleaning#Data normalization#Unit standardization

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice