Microsoft Power BI Data Analyst — Question 38

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?

Answer options

• A. Disable fuzzy matching.
• B. Enable fuzzy matching.
• C. Set Join Kind to Left Outer.

Correct answer: B

Explanation

Enabling fuzzy matching allows Power BI to match similar but not identical values, which is essential given that the data from the web form may contain inconsistencies. Disabling fuzzy matching (Option A) would hinder the merge process, while simply setting the Join Kind to Left Outer (Option C) does not address the potential data discrepancies.