nerdexam
Microsoft

DP-100 · Question #353

You are profiling data by using Azure Machine Learning studio. You need to detect columns with odd or missing values. Which statistic should you analyze?

The correct answer is C. Error count. When profiling data in Azure Machine Learning studio to detect columns with odd or missing values, you should analyze the 'Error count' statistic.

Explore data and run experiments

Question

You are profiling data by using Azure Machine Learning studio. You need to detect columns with odd or missing values. Which statistic should you analyze?

Options

  • AProfile
  • BStd deviation
  • CError count
  • DType

How the community answered

(21 responses)
  • B
    5% (1)
  • C
    90% (19)
  • D
    5% (1)

Why each option

When profiling data in Azure Machine Learning studio to detect columns with odd or missing values, you should analyze the 'Error count' statistic.

AProfile

'Profile' is a general term referring to the overall data profiling report, not a specific statistic used to pinpoint odd or missing values.

BStd deviation

'Std deviation' (standard deviation) measures the spread or dispersion of data points around the mean, which is useful for understanding variability but does not directly identify individual odd or missing values.

CError countCorrect

The 'Error count' statistic in Azure Machine Learning's data profiling explicitly quantifies the number of invalid or missing values within a particular column. This directly helps identify data quality issues such as odd or missing entries that do not conform to expected patterns or types.

DType

'Type' refers to the inferred data type of a column, and while type mismatches can cause errors, the 'Error count' is the metric that directly reports the number of problematic entries.

Concept tested: Azure ML data profiling error detection

Source: https://learn.microsoft.com/en-us/azure/machine-learning/concept-data-quality-monitoring?view=azureml-api-2#data-profiling

Topics

#Data Profiling#Data Quality#Missing Values#Error Detection

Community Discussion

No community discussion yet for this question.

Full DP-100 Practice