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 the use of the add_data_tap stored procedure.
Which of the following is TRUE with regards to using add_data_tap stored procedure? (Choose all
that apply.)

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 the use of Slowly Changing Dimension Transformation Outputs. One of the output
options are used to update the record in the lookup table.
Which of the following is the output option?

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 upload a file to a table in a SQL Azure database.
You need to make sure that the code includes an event handler that makes use of an executable
to raise the event when its verification is completed.
Which of the following is the event handler that you should use?

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 replication type that is used when subscribers need to receive data, make changes
offline, and later synchronize changes with the Publisher and other Subscribers.
Which of the following is the replication type being discussed?

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 a fixed server-level role that allows the ability to create, alter, drop, and restore any
database.
Which of the following is the fixed server-level role you are discussing?

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 an index that ensures the index key contains no duplicate values.
Which of the following is the index being discussed?

You work as a senior database developer 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 developers. You are
discussing the SorABCeyPosition property for a data flow.
Which of the following represents the data type for this property?

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 an index that provides efficient support for sophisticated word searches in character

string data.
Which of the following is the index being discussed?

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 a fixed server-level role that does not allow its members to add, modify, or delete any
data in the user tables within a database.
Which of the following is the fixed server-level role you are discussing?

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 have received reports regarding a current existing SQL Server Integration Services (SSIS)
package not completing its execution, and not transferring data. You have decided to make use of

the Project Deployment Model.
Which of the following is TRUE with regards to using the Project Deployment Model?