DP-600 · Question #72
DP-600 Question #72: Real Exam Question with Answer & Explanation
The correct answer is B: Merge the queries by using fuzzy matching.. 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. https://learn.microsoft.com/en-us/powerquery-m/table-fuzzyjoin ht
Question
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?
Options
- AAppend the queries by using fuzzy matching.
- BMerge the queries by using fuzzy matching.
- CAppend the queries by using a lookup table.
- DMerge the queries by using a lookup table.
Explanation
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. https://learn.microsoft.com/en-us/powerquery-m/table-fuzzyjoin https://learn.microsoft.com/en-us/power-query/merge-queries-fuzzy-match
Topics
Community Discussion
No community discussion yet for this question.