Microsoft
70-458 · Question #14
You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation. The reference data to be used in the transformation does not change. You need to reuse…
The correct answer is A. Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor. See the full explanation below for the reasoning.
Question
You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation. The reference data to be used in the transformation does not change. You need to reuse the Fuzzy Lookup match index to increase performance and reduce maintenance. What should you do?
Options
- ASelect the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor.
- BSelect the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor.
- CSelect the DropExistingMatchlndex option in the Fuzzy Lookup Transformation Editor.
- DExecute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure
- EExecute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure.
How the community answered
(57 responses)- A79% (45)
- B5% (3)
- C4% (2)
- D11% (6)
- E2% (1)
Community Discussion
No community discussion yet for this question.