nerdexam
Microsoft

PL-300 · Question #60

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 A. Yes. To ensure nonnumeric values in the CustomerID column, which cause errors, are set to 0, you should use the 'Replace Errors' feature in Power Query Editor.

Submitted by paula_co· 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 CustomerID. The Data Type of CustomerID 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 CustomerID column are set to 0. Solution: From Query Editor, select the CustomerID column. Click Replace Errors... and enter a value of. Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(22 responses)
  • A
    77% (17)
  • B
    23% (5)

Why each option

To ensure nonnumeric values in the CustomerID column, which cause errors, are set to 0, you should use the 'Replace Errors' feature in Power Query Editor.

AYesCorrect

In Power Query Editor, selecting the CustomerID column and using 'Replace Errors' allows you to specify a value, such as 0, to substitute for any cells that currently contain errors. This directly addresses the requirement to set nonnumeric values, which manifest as errors, to 0.

BNo

If the solution described (which is missing from the question but implies a direct method) does not involve replacing errors, it would fail to meet the goal of setting nonnumeric error values to 0.

Concept tested: Power Query error handling (replace errors)

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

Topics

#Power Query#Data Transformation#Error Handling#Data Cleaning

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PL-300 Practice