Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Because the Contacts table is filled from a web form and the data is not sanitized, the column Customer Name in Contacts will often have: typos inconsistent casing extra spaces slight variations (e.g., “Contoso Ltd”, “contoso”, “Contoso Limited”) If you try to merge using exact matching, many rows will fail to match, even though they belong to the same customer.
* Answer: - B. Enable fuzzy matching. * Explanation: - The Contacts table uses a web-based form and the data is not sanitized, meaning the Customer Name values may have typos, inconsistent casing, or extra spaces. - A standard merge (exact match) would fail for these variations. - Fuzzy matching in Power Query allows approximate matches between text values, which is ideal for this scenario. * Why not the others: - A. Disable fuzzy matching: This would require exact matches, which is not suitable for unsanitized data. - C. Set Join Kind to Left Outer: This controls which rows are included after the merge, but does not solve the issue of inconsistent names.
"Data is not sanitized." = Enable Fuzzy Matching