nerdexam
Microsoft

PL-300 · Question #432

You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns: - Customer_Name - Customer ID - Website The Contacts table contains the…

The correct answer is B. Enable fuzzy matching. To merge tables with unsanitized 'Customer Name' data, you should enable fuzzy matching in Power Query.

Submitted by yuriko_h· Apr 18, 2026

Question

You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns:

  • Customer_Name
  • Customer ID
  • Website

The Contacts table contains the following columns:

  • Contact ID
  • Contact Email
  • Contact Name
  • Customer Name

A web-based contact form is used to fill the Contacts table. The data is not sanitized. You need to create a merge for the Customer and Contacts tables. What should you do?

Options

  • ADisable fuzzy matching.
  • BEnable fuzzy matching.
  • CSet Join Kind to Left Outer.

How the community answered

(18 responses)
  • A
    17% (3)
  • B
    72% (13)
  • C
    11% (2)

Why each option

To merge tables with unsanitized 'Customer Name' data, you should enable fuzzy matching in Power Query.

ADisable fuzzy matching.

Disabling fuzzy matching would require exact matches between the 'Customer Name' columns, which would likely result in many unmatched records due to the unsanitized data.

BEnable fuzzy matching.Correct

Enabling fuzzy matching in Power Query allows the merge operation to match rows based on approximate text matching, which is essential when joining columns like 'Customer Name' that might have inconsistencies due to unsanitized input, such as typos or variations in spacing or casing.

CSet Join Kind to Left Outer.

Setting the Join Kind to Left Outer defines how rows from the second table are included in the result, but it does not address the fundamental issue of matching inconsistent text data between the join columns themselves.

Concept tested: Power Query fuzzy matching for data cleansing

Source: https://learn.microsoft.com/en-us/power-query/merge-queries-fuzzy-match

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice