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.
Answer: C
You work as a senior 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 running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing data quality projects.
Which of the following are benefits of data quality projects? (Choose all that apply.)
A. It enables you to perform data cleansing on your source data by using the knowledge in a DQS knowledge base.
B. It allows you to perform data matching on your source data by using the knowledge in a DQS knowledge base.
C. It allows you to perform data matching on your source data by using the matching policy in a knowledge base.
D. It enables you to perform data cleansing on your source data by using the matching policy in a knowledge base.
Answer: AC
No comments:
Post a Comment
Note: only a member of this blog may post a comment.