Implementing Analytics Solutions Using Microsoft Fabric — Question 95

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?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because merging queries with fuzzy matching allows for handling variations in data, such as ignoring spaces. Options A and C do not utilize the best method for minimizing development effort with respect to inner joins, while D uses a lookup table which isn't as effective as fuzzy matching for this scenario.