Exam DP-600 topic 1 question 79 discussion

Actual exam question from Microsoft's DP-600

Question #: 79
Topic #: 1

You have a Fabric workspace named Workspace1 and an Azure SQL database.

You plan to create a dataflow that will read data from the database, and then transform the data by performing an inner join.

You need to ignore spaces in the values when performing the inner join. The solution must minimize development effort.

What should you do?

A. Append the queries by using fuzzy matching.
B. Merge the queries by using fuzzy matching.
C. Append the queries by using a lookup table.
D. Merge the queries by using a lookup table.

Show Suggested Answer

Suggested Answer: B 🗳️

by 9878eb9 at April 15, 2024, 9:58 a.m.

Comments

Submit Cancel

9878eb9

Highly Voted 9 months, 1 week ago

Fuzzy Matching: Fuzzy matching allows you to match data even when there are minor differences, such as extra spaces, in the values. This eliminates the need to manually clean or preprocess the data before the join.

upvoted 23 times

...

Mhunity

Most Recent 7 months, 1 week ago

Selected Answer: B

Merge = join append = union so the answer is B why? Fuzzy Matching: Fuzzy matching allows you to match data even when there are minor differences, such as extra spaces, in the values. This eliminates the need to manually clean or preprocess the data before the join.

upvoted 2 times

...

stilferx

8 months, 1 week ago

Selected Answer: B

IMHO, B is good. Not append (append is like UNION). Not D, because spaces, and we need minimal efforts

upvoted 4 times

...

4371883

8 months, 4 weeks ago

Selected Answer: B

Merge as the requirement is for inner join. doc on fuzzy join and fuzzy match: https://learn.microsoft.com/en-us/powerquery-m/table-fuzzyjoin https://learn.microsoft.com/en-us/power-query/merge-queries-fuzzy-match

upvoted 3 times

...

Nefirs

9 months ago

Selected Answer: B

B should be correct

upvoted 3 times

...