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.
ABC.com has a Storage Area Network that hosts a Sales database. The data file of the Sales
database is 1 TB in size, and is stored on a dedicated LUN that only has 500 GB of useable space

left. The transaction log of the Sales database is 5 GB in size, and is stored on a dedicated LUN
that only has 2.5 GB of useable space left.
A full backup is configured to occur weekly on a Sunday at 10 AM. You have been instructed to
configure backups to occur at 3 hour intervals on a daily basis, Monday to Friday. The first daily
backup should occur at 8 AM, and the last should be at 5 PM. Furthermore, you are informed that
the backups should be minimal in size.
Which of the following actions should you take?

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 ofSlowly 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 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 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 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 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 developing a SQL Server Master Data Services (MDS) model.
ABC.com’s source data is hosted by a single table. The table includes the manager-to-subordinate
relationships.
You now have to design a hierarchy that suits ABC.com’s organizational structure.
Which of the following actions should you take?

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 installing the Business Intelligence features. You are currently
performing the post-installation of the Data Quality Server component of SQL Server Data Quality
Services (DQS).
Which of the following actions should you take to conclude the Data Quality Server installation?

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 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?