Microsoft
PL-300 · Question #357
PL-300 Question #357: Real Exam Question with Answer & Explanation
Sign in or unlock PL-300 to reveal the answer and full explanation for question #357. The question stem and answer options stay visible for context.
Submitted by naveen.iyer· Apr 18, 2026
Question
You have data in a Microsoft Excel worksheet as shown in the following table. You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements: - If the discount column returns an error, a discount of 0.05 must be used. - All the rows of data must be maintained. - Administrative effort must be minimized. What should you do in Power Query Editor?
Exhibit
Options
- ASelect Replace Errors.
- BEdit the query in the Query Errors group.
- CSelect Remove Errors.
- DSelect Keep Errors.
Unlock PL-300 to see the answer
You've previewed enough free PL-300 questions. Unlock PL-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.