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.