PL-300 Question #432: Real Exam Question with Answer & Explanation

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.

Explanation

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

Common mistakes.

• A. 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.
• C. 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

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

No community discussion yet for this question.