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

Exam DP-100 All Questions

View all questions & answers for the DP-100 exam
Go to Exam

Exam DP-100 topic 1 question 16 discussion

Actual exam question from Microsoft's DP-100
Question #: 16
Topic #: 1
[All DP-100 Questions]

This question is included in a number of questions that depicts the identical set-up. However, every question has a distinctive result. Establish if the recommendation satisfies the requirements.
You are in the process of creating a machine learning model. Your dataset includes rows with null and missing values.
You plan to make use of the Clean Missing Data module in Azure Machine Learning Studio to detect and fix the null and missing values in the dataset.
Recommendation: You make use of the Remove entire row option.
Will the requirements be satisfied?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by ranjsi01 at Jan. 30, 2022, 3:57 p.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
klowqw
Highly Voted 2 years, 8 months ago
not really if you have just a null in a one cell, you don't have to delete the whole row
upvoted 7 times
Edriv
2 years, 4 months ago
Good point!
upvoted 1 times
...
Mirjalol
2 years, 3 months ago
Answer is correct. Here is the reference: https://learn.microsoft.com/en-us/azure/machine-learning/component-reference/clean-missing-data
upvoted 3 times
...
...
ranjsi01
Highly Voted 3 years, 3 months ago
correct
upvoted 6 times
Gabonia
2 years, 8 months ago
I agree
upvoted 1 times
...
...
vkm_97
Most Recent 1 month, 2 weeks ago
Selected Answer: B
Azure Machine Learning Studio provides multiple ways to handle missing data, including mean, median, mode, and custom substitution. Avoid deleting rows unless absolutely necessary, as it can introduce bias and reduce the dataset size. The best approach depends on the context, but Microsoft emphasizes data preservation wherever possible.
upvoted 1 times
...
ZIMARAKI
7 months, 1 week ago
Selected Answer: A
From Microsoft Documentation: This component supports multiple types of operations for "cleaning" missing values, including: Replacing missing values with a placeholder, mean, or other value Completely removing rows and columns that have missing values Inferring values based on statistical methods
upvoted 1 times
fcoguerrero88
1 year, 7 months ago
That's fine, but that is an option that the module allows you, however, it is not advisable to delete an entire row for a null value when there are relevant columns for the model and it has records in the dataset. I think that from that point of view, the correct answer is B.
upvoted 2 times
...
...
james2033
7 months, 1 week ago
Selected Answer: A
CLEANING MODE: REMOVE ENTIRE ROW Quote 'Remove entire row: Completely removes any row in the dataset that has one or more missing values. This is useful if the missing value can be considered randomly missing.'
upvoted 2 times
...
james2033
7 months, 1 week ago
Selected Answer: A
https://learn.microsoft.com/en-us/previous-versions/azure/machine-learning/studio-module-reference/clean-missing-data#bkmk_ReplaceMissing - Replace using MICE (Multivariate Imputation using Chained Equations) - Custom substitution value - Replace with mean - Replace with median: Calculates the column median value, and uses the median value as the replacement for any missing value in the column. - Replace with mode - Remove entire row (*) - Replace using Probabilistic PCA 'rows with null and missing values', we can removing entire row. I choose YES (*)
upvoted 2 times
...
evangelist
7 months, 1 week ago
Selected Answer: A
allowed options: The Clean Missing Data module offers several options for handling missing data, including: Remove entire row: Removes any row with missing values. Replace using mean/median/mode: Replaces missing values with the mean, median, or mode of the column. Replace with custom value: Replaces missing values with a custom value specified by the user. Replace using MICE: Uses Multiple Imputation by Chained Equations to replace missing values.
upvoted 1 times
...
mhmichiel
2 years, 1 month ago
Selected Answer: A
correct
upvoted 1 times
...
ManuelHenriques
2 years, 2 months ago
Selected Answer: B
What if you dataset is not very large and it gets compromised with removing rows? As we do not have that information I think it is not suitable to go for remove rows, so B.
upvoted 1 times
...
Cococo
2 years, 2 months ago
Read this again - "to detect and fix the null and missing values" FIX, not remove them, not delete them, not get rid of them but FIX (replace with median is the answer I think). Remove entire row: Completely removes any row in the dataset with one or more missing values.
upvoted 2 times
...
Mirjalol
2 years, 3 months ago
Selected Answer: A
Answer is correct. Here is the reference: https://learn.microsoft.com/en-us/azure/machine-learning/component-reference/clean-missing-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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago