Microsoft
70-774 · Question #30
You have a dataset that is missing values in a column named Column3. Column3 is correlated to two columns named Column4 and Column5. You need to improve the accuracy of the dataset, while minimizing…
The correct answer is A. Replace the missing values in Column3 by using probabilistic Principal Component Analysis (PCA). See the full explanation below for the reasoning.
Question
You have a dataset that is missing values in a column named Column3. Column3 is correlated to two columns named Column4 and Column5. You need to improve the accuracy of the dataset, while minimizing data loss. What should you do?
Options
- AReplace the missing values in Column3 by using probabilistic Principal Component Analysis (PCA).
- BRemove all of the rows that have the missing values in Column4 and Column5.
- CReplace the missing values in Column3 with a mean value.
- DRemove the rows that have the missing values in Column3.
How the community answered
(41 responses)- A78% (32)
- B7% (3)
- C2% (1)
- D12% (5)
Community Discussion
No community discussion yet for this question.