Exam PL-300 topic 1 question 43 discussion

Actual exam question from Microsoft's PL-300

Question #: 43
Topic #: 1

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?

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

Show Suggested Answer

Suggested Answer: B 🗳️

by NyashaDuri at Jan. 9, 2025, 3:36 a.m.

Comments

Submit Cancel

NyashaDuri

Highly Voted 3 months, 2 weeks ago

Selected Answer: B

First Why enable fuzzy matching? Since it says the Contacts table is filled using a web-based form without data sanitisation, there may be inconsistencies in how customer names are entered. Fuzzy matching will help match similar strings, accommodating for typos, capitalisation differences, and other minor variations in the customer names. "No confusion, and no need to discuss further" /s jk feedback welcome especially where I might be mistaken

upvoted 23 times

...

Zander3

Most Recent 2 months, 1 week ago

Selected Answer: B

Because the Contacts table is populated via a web-based form and the data isn't sanitized, you may encounter typos or formatting differences in the "Customer Name" field. Enabling fuzzy matching allows the merge to identify similar entries even if they're not an exact match, ensuring a more accurate join between the Customer and Contacts tables.

upvoted 4 times

...

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 43 discussion

Comments

NyashaDuri

Zander3

SY0-701