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.
http://technet.microsoft.com/zh-tw/library/ms137786.aspx
D.
It allows for a new index to be created, saved, and maintained.
https://msdn.microsoft.com/en-us/library/ms137786.aspx
Option
Description
GenerateAndMaintainNewIndex
Create a new index, save it, and maintain it. The transformation installs triggers on the reference table to keep the reference table and index table synchronized.
GenerateAndPersistNewIndex
Create a new index and save it, but do not maintain it.
GenerateNewIndex
Create a new index, but do not save it.
ReuseExistingIndex
Reuse an existing index.
C -GenerateAndPersistNewIndex – Create a new index and save it, but do not maintain it.
https://msdn.microsoft.com/en-us/library/ms137786.aspx
GenerateAndMaintainNewIndex
Create a new index, save it, and maintain it. The transformation installs triggers on the reference table to keep the reference table and index table synchronized.
GenerateAndPersistNewIndex
Create a new index and save it, but do not maintain it.
GenerateNewIndex
Create a new index, but do not save it.
ReuseExistingIndex
Reuse an existing index.
GenerateAndPersistNewIndex
C. Create a new index and save it, but do not maintain it.