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 2 question 19 discussion

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

You are creating a machine learning model. You have a dataset that contains null rows.
You need to use the Clean Missing Data module in Azure Machine Learning Studio to identify and resolve the null and missing data in the dataset.
Which parameter should you use?

  • A. Replace with mean
  • B. Remove entire column
  • C. Remove entire row
  • D. Hot Deck
  • E. Custom substitution value
  • F. Replace with mode
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Abhinav_nasaiitkgp at Jan. 15, 2021, 9:43 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
ljljljlj
Highly Voted 3 years, 4 months ago
On exam 2021/7/10
upvoted 8 times
...
Ejire
Most Recent 5 months, 2 weeks ago
The correct answer is C. If you need voucher for any DP or AI exam contact me on +2348139103938
upvoted 1 times
...
krishna1818
1 year, 5 months ago
Selected Answer: C
Remove the entire row if there are less number of missing values
upvoted 1 times
...
MarinaMijailovic
1 year, 6 months ago
Selected Answer: C
Null rows means the entire the row is null so C
upvoted 2 times
...
David_Tadeu
2 years, 7 months ago
Selected Answer: C
Remove entire row: removes a row which contains a null value for a specified (it is a parameter of this procedure) set of columns
upvoted 1 times
...
synapse
2 years, 8 months ago
Selected Answer: C
"Null Rows" So I am going with C
upvoted 2 times
...
guddusao
3 years, 3 months ago
I think mode will work both numerical and categorical data. May be mode can impute the missing value.
upvoted 1 times
...
Abdulraoufhakeem
3 years, 4 months ago
I agree to answer C
upvoted 2 times
...
Haet
3 years, 6 months ago
Answer C is correct
upvoted 3 times
...
dev2dev
3 years, 7 months ago
A, B, C and F are valid.
upvoted 3 times
Dasist
3 years, 7 months ago
They are not since we are only targeting NULL rows. C is correct
upvoted 6 times
...
...
Abhinav_nasaiitkgp
3 years, 10 months ago
How other options are not valid? We can impute missing values with mean median and mode also. Something is missing in the question
upvoted 3 times
allanm
3 years, 5 months ago
If you have ENTIRE rows that are null, chances are you don't need them.
upvoted 6 times
...
Adrien_B
3 years, 9 months ago
"You have a dataset that contains null rows" : If all the columns are Null for the row you don't need to keep it
upvoted 6 times
...
ck1729
3 years, 9 months ago
you can replace with mean or mode only if the column is of integer type since the values are nulls here it implies the data type is String or text. and hence from the options give only remove rows looks like the correct answer.
upvoted 2 times
ML_Novice
2 years, 12 months ago
hello ck1729 Does null means that the data type is only String or text ? Does this implies that missing values for integers and float are Nan and not Null? Otherwise how can we know the datatype of the missing values pleas
upvoted 1 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