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 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 are using a SQL Server Integration Services (SSIS) project that is stored in the SSIS catalog. An
Environment has been defined in the SSIS catalog. You need to add the Environment to the project. Which
stored procedure should you 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 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 raisethe
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 needto 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?