You work as a database administrator at ABC.com. The ABC.com network consists of a single
domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are in the process of creating a SQL Server Integration Services (SSIS) package. The
package will be configured to make use of the GenerateAndPersistNewIndex Fuzzy Lookup
transformation option.
Which of the following is the purpose of this option?
A.
It allows for a current index to be reused.
B.
It allows for a new index to be created, without saving it.
C.
It allows for a new index to be created and saved, without maintaining it.
D.
It allows for a new index to be created, saved, and maintained.
Explanation: