
Answer-first summary for fast verification
Answer: Merge the queries by using fuzzy matching.
The correct answer is B. Merging queries using fuzzy matching allows you to perform an inner join while ignoring minor differences, such as extra spaces, in the values. This approach minimizes the need for manual data cleaning or preprocessing. Fuzzy matching ensures that the join operation can still match records even if there are small inconsistencies in the data, thus reducing overall development effort.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are managing a Fabric workspace called Workspace1 and working with an Azure SQL database. Your objective is to set up a dataflow that extracts data from the Azure SQL database and then processes this data by executing an inner join operation. It is crucial that spaces within the data values are disregarded when carrying out this inner join. Additionally, the approach you choose should aim to reduce the amount of development effort required. What steps should you take to achieve this?
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.
No comments yet.