Exam 70-767 topic 1 question 90 discussion

Actual exam question from Microsoft's 70-767

Question #: 90
Topic #: 1

HOTSPOT -
You are designing a data transformation process using Microsoft SQL Server Integration Services (SSIS).
You need to ensure that every row is compared with every other row during transformation.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer: Explanation
When you configure the Fuzzy Grouping transformation, you can specify the comparison algorithm that the transformation uses to compare rows in the transformation input. If you set the Exhaustive property to true, the transformation compares every row in the input to every other row in the input. This comparison algorithm may produce more accurate results, but it is likely to make the transformation perform more slowly unless the number of rows in the input is small.
References:
https://docs.microsoft.com/en-us/sql/integration-services/data-flow/transformations/fuzzy-grouping-transformation

by m8rvil at March 4, 2020, 7:58 a.m.