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?
A.
Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation
Editor.
B.
Select the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor.
C.
Select the DropExistingMatchlndex option in the Fuzzy Lookup Transformation Editor.
D.
Execute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure.
E.
Execute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure.
Explanation:
Reference: http://msdn.microsoft.com/en-us/library/ms137786.aspx
Correct answer is B. There’s no ‘GenerateAndPersistNewIndex’ option in the Fuzzy Lookup Transformation Editor. What you have on the General Page of the editor is the ‘GenerateNewIndex’ option.
https://msdn.microsoft.com/en-us/library/ms137786.aspx
GenerateAndPersistNewIndex
->
Create a new index and save it, but do not maintain it.
GenerateNewIndex
->
Create a new index, but do not save it.
i think the correct answer is A
A is the answer
https://msdn.microsoft.com/en-gb/library/ms137786.aspx