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 recently created an SQL Server Integration Services (SSIS) project catalog that contains
two Environments. A single Environment Variable, named ConnectionString, of type string is
specified by each environment. The project also has a project Connection Manager configured to
link up with the data warehouse.
You have been instructed to make sure that deployed packages are executed using any of the
specified Environments.
Which of the following suitably describes an Environment Variable?

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 hosting a training exercise for ABC.com’s junior database developers. You are currently
discussing an EventHandlerClass property that is used to retrieve or configure a value that
indicates whether the container participates in transactions.

Which of the following is the EventHandlerClass property that 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 the effects of setting IsolationLevel transaction property of a Data Flow task to Chaos.
Which of the following suitably describes the effect?

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 directly after it has finished running.

Which of the following is the event handler that you should use?

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 import data into a SQL Azure hosted data warehouse.
You have decided to make use of the Environment Variable package configuration as part of your
solution.
Which of the following is TRUE with regards to the Environment Variable package configuration?

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 hosting a training exercise for Microsoft SQL Server 2012 administrators. You are
currently discussing the Fuzzy Lookup transformation.

Which of the following is TRUE with regards to the Fuzzy Lookup similarity threshold setting?
(Choose all that apply.)

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 created a SQL Server Integration Services (SSIS) project that you are preparing to
deploy using the Integration Services Deployment Wizard.
Which of the following is the third step in the Integration Services Deployment Wizard’s process?

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 Package Deployment Model.

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

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?