70-463 · Question #120
You are hosting a training exercise for Microsoft SQL Server 2012 administrators. You are currently discussing the Fuzzy Lookup transformation. Which of the following is TRUE with regards to the…
The correct answer is A. Increasing the threshold can improve the speed of matching. C. The nearer the value is to 1, the nearer the resemblance of the lookup value to the source. In the SSIS Fuzzy Lookup transformation, a higher similarity threshold means only closer matches qualify, which reduces the candidate set and can improve matching speed, and a value near 1 indicates near-identical resemblance.
Question
You are hosting a training exercise for Microsoft SQL Server 2012 administrators. You are currently discussing the Fuzzy Lookup transformation. Which of the following is TRUE with regards to the Fuzzy Lookup similarity threshold setting? (Choose all that apply.)
Options
- AIncreasing the threshold can improve the speed of matching.
- BIncreasing the threshold can deteriorate the speed of matching.
- CThe nearer the value is to 1, the nearer the resemblance of the lookup value to the source
- DThe nearer the value is to 1, the further the resemblance of the lookup value to the source
How the community answered
(38 responses)- A95% (36)
- B3% (1)
- D3% (1)
Why each option
In the SSIS Fuzzy Lookup transformation, a higher similarity threshold means only closer matches qualify, which reduces the candidate set and can improve matching speed, and a value near 1 indicates near-identical resemblance.
Increasing the similarity threshold narrows the set of candidate matches the transformation must evaluate, because only records meeting the higher similarity bar are considered - this reduces processing work and can improve matching speed.
Increasing the threshold reduces - not deteriorates - matching speed by eliminating lower-quality candidates from consideration earlier in the process.
The similarity threshold value ranges from 0 to 1, where a value nearer to 1 requires the lookup value to be very similar to the source value, meaning a near-exact resemblance is required for a match to be returned.
A value near 1 means nearer resemblance is required, which is the opposite of this choice's claim that it indicates further resemblance.
Concept tested: SSIS Fuzzy Lookup transformation similarity threshold
Source: https://learn.microsoft.com/en-us/sql/integration-services/data-flow/transformations/fuzzy-lookup-transformation
Topics
Community Discussion
No community discussion yet for this question.