Microsoft
70-463 · Question #120
70-463 Question #120: Real Exam Question with Answer & Explanation
The correct answer is A: Increasing the threshold can improve the speed of matching.. 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
Explanation
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.
Common mistakes.
- B. Increasing the threshold reduces - not deteriorates - matching speed by eliminating lower-quality candidates from consideration earlier in the process.
- D. 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
Community Discussion
No community discussion yet for this question.