Power BI Data Analyst (PL-300) · Free practice question 2 of 12
Fuzzy matching merge
Supplier names from two systems at Ostrava Metals differ slightly, for example "Brandt Steel GmbH" and "Brandt Steel Gmbh.". An exact merge leaves many suppliers unmatched. Which Power Query option is designed for this situation?
- A.Enable fuzzy matching in the Merge dialog and adjust the similarity threshold
- B.Use an Inner join instead of a Left outer join
- C.Append the two supplier queries
- D.Change the supplier name columns to the Whole number type
Show answer and explanation
Correct answer: A. Enable fuzzy matching in the Merge dialog and adjust the similarity threshold
Why: Fuzzy matching compares text values by similarity rather than exact equality, and its similarity threshold and options such as ignoring case control how close values must be to match. Changing the join kind does not make near-identical names equal. Appending stacks rows without matching them, and text names cannot be converted to whole numbers.