nerdexam
Microsoft

PL-300 · Question #194

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might…

The correct answer is B. No. To replace nonnumeric values in a 'Whole Number' column with 0 during data refresh, the 'Replace Errors' feature in Power Query Editor is required.

Submitted by rachelw· Apr 18, 2026Prepare the data

Question

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a query for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD is Whole Number. You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values. You need to ensure that nonnumeric values in the CustomerlD column are set to 0. Solution: From Query Editor, select the CustomerlD column and click Remove Errors. Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(53 responses)
  • A
    19% (10)
  • B
    81% (43)

Why each option

To replace nonnumeric values in a 'Whole Number' column with 0 during data refresh, the 'Replace Errors' feature in Power Query Editor is required.

AYes

Simply selecting a column or a generic error handling option from Query Editor typically leads to either removing rows with errors or leaving the errors, neither of which fulfills the requirement of setting nonnumeric values to 0.

BNoCorrect

No, the solution is incomplete and implies an action that would likely not achieve the goal; to specifically set nonnumeric values to 0 in a column with data type errors, one must explicitly use the 'Replace Errors' feature in Power Query Editor and specify '0' as the replacement value.

Concept tested: Power Query error handling (Replace Errors)

Source: https://learn.microsoft.com/power-query/replace-errors

Topics

#Power Query Editor#Error Handling#Data Transformation#Replace Errors

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PL-300 Practice