nerdexam
Microsoft

70-458 · Question #45

You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night. The SQL Azure data contains many misspellings and variations of…

The correct answer is B. Change the similarity threshold to 0.55. The similarity thresholds can be set at the component and join levels. The join-level similarity threshold is only available when the transformation performs a fuzzy match between columns in the input and the reference table. The similarity range is 0 to 1. The closer to 1 the…

Manage Data

Question

You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night. The SQL Azure data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest- matching string from a reference table of allowed values. The number of rows in the reference table is very large. If no acceptable match is found, the Fuzzy Lookup transformation passes a null value. The current setting for the Fuzzy Lookup similarity threshold is 0.50. Many values are incorrectly matched. You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance. What should you do?

Options

  • ADecrease the maximum number of matches per lookup.
  • BChange the similarity threshold to 0.55.
  • CChange the Exhaustive property to True.
  • DIncrease the maximum number of matches per lookup.

How the community answered

(36 responses)
  • A
    3% (1)
  • B
    78% (28)
  • C
    8% (3)
  • D
    11% (4)

Explanation

The similarity thresholds can be set at the component and join levels. The join-level similarity threshold is only available when the transformation performs a fuzzy match between columns in the input and the reference table. The similarity range is 0 to 1. The closer to 1 the threshold is, the more similar the rows and columns must be to qualify as duplicates.

Topics

#Fuzzy Lookup#SSIS#similarity threshold#data cleansing

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-458 Practice