You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domainnamed 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 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 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 have been asked to revise a SQL Server Integration Services (SSIS) package. The package only includes
Execute SQL tasks.
To make sure that, in the event of an Execute SQL task failing, changes made by all of the Execute SQL tasks
is rolled back. To do this, you want to alter the TransactionOption property of the package.
Which of the following is the value that must be set for the TransactionOption property of the package?

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.)

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 have decided to
make use of Expression Task.
Which of the following is TRUE with regards to Expression Task?

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?

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
Multicast transformation.
Which of the following is TRUE with regards to Multicast transformation? (Choose two.)

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
ValidateExternalMetaData 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 the
use of Slowly Changing Dimension Transformation Outputs. One of the output options causes Derived Column
transformations to create columns for the expired row and the current row indicators.
Which option is the output that causes this?

You are designing an enterprise star schema that will consolidate data from three independent data
marts. One of the data marts is hosted on SQL Azure. Most of the dimensions have the same
structure and content. However, the geography dimension is slightly different in each data mart. You
need to design a consolidated dimensional structure that will be easy to maintain while ensuring
that all dimensional data from the three original solutions is represented. What should you do?