PL-300 Question 26

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A1

  * Answer: A. Select Replace Errors. * Explanation: You must keep all rows and substitute any error in the Discount column with 0.05. Replace Errors lets you specify a replacement value for error cells in a column—exactly matching the requirement with minimal effort. * Other options: - C.Remove Errors → deletes rows containing errors (violates “maintain all rows”). - D.Keep Errors → keeps only the error rows (also violates “maintain all rows”). - B.Edit the query in the Query Errors group → not the right action for replacing error values; and there isn’t a standard “Query Errors” group used for this scenario.

• Chose A2

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

• 1

  Correct answer