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. You are
including a custom task element to deal with complicated scientific information derived from a SQL
Azure database.
You want to test the custom task element prior to deploying it into the production environment.
You have to make sure that the custom task element is properly deployed into the testing
environment.
Which of the following actions should you take?

You work as a 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 administrators. You are
discussing the use of a stored procedure that creates an environment reference for a project in the
SSIS catalog.
Which of the following is the stored procedure 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 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?