Exam PL-300 topic 1 question 26 discussion

A. Select Replace Errors. is the correct answer. Because selecting "Replace Errors" allows you to replace any errors in the discount column with a specified value, which in the case is 0.05 as per the requirement. Option B is not necessary for this specific task. Option C would remove rows with errors entirely, which is not in line with the requirement to maintain all rows of data. Option D would keep rows with errors as they are, which is not what we want since we want to replace errors with a specific value.

THE ANSWERE IS A

We can directly replace errors with 0.05. It is the quickest way to do that. A -Select Replace Errors is correct

Correct answer

A for me

Replace Errors

Replace the errors, pretty straight forward

c'est correct mon reuf

The correct option to achieve the requirements is: A. Select Replace Errors. By selecting "Replace Errors" in Power Query Editor, you can specify a value (in this case, 0.05) to be used whenever an error is encountered in the specified column (discount column). This ensures that if the discount column returns an error, a discount of 0.05 will be used, while maintaining all rows of data and minimizing administrative effort.

A - Select Replace Errors is correct

A. Select Replace Errors - is correct. C&D will remove some rows Option B, "Edit the query in the Query Errors group", would technically also allow to achieve the required result. However, this would not be the optimal solution given the constraints provided in the scenario, which specifies that administrative effort must be minimized.