Which three actions should you perform in sequence?
DRAG DROP
You administer a Microsoft SQL Server 2012 database.
The database uses SQL Server Agent jobs to perform regular FULL and LOG backups. The
database uses the FULL recovery model.
You plan to perform a bulk import of a very large text file.
You need to ensure that the following requirements are met during the bulk operation:
The database transaction log is minimally affected.
The database is online and all user transactions are recoverable.
All transactions are fully recoverable prior to the import.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
You need to complete the mapping of the Group column
You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client
application to modify an existing knowledge base.
In the mapping configuration, two of the three columns are mapped to existing domains in
the knowledge base. The third column, named Group, does not yet have a domain.
You need to complete the mapping of the Group column.
What should you do?
What should you create?
You administer a Microsoft SQL Server 2012 database named Contoso on a server named
Server01.
You need to write messages to the Application Log when users are added to or removed
from a fixed server role in Server01.
What should you create?
Which SQL Server application should you use?
You are installing SQL Server Data Quality Services (DQS).
You need to give specific users access to the Data Quality Server.
Which SQL Server application should you use?
What should you create?
You administer a Microsoft SQL Server 2012 database named Contoso on a server named
Server01.
You need to be notified immediately when fatal errors occur on Server01.
What should you create?
What should you create?
You administer a Microsoft SQL Server 2012 database named Contoso on a server named
Server01.
You need to diagnose deadlocks that happen when executing a specific set of stored
procedures by recording events and playing them back on a different test server.
What should you create?
You need to complete the post-installation configuration
You are completing the installation of the Data Quality Server component of SQL Server
Data Quality Services (DQS).
You need to complete the post-installation configuration.
What should you do?
What should you create?
You administer a Microsoft SQL Server 2012 database named Contoso on a server named
Server01.
You need to prevent users from disabling server audits in Server01.
What should you create?
You need to ensure that if any of the three Execute SQL product tasks fail, all three tasks will roll back the
You are editing a SQL Server Integration Services (SSIS) package that contains three
Execute SQL tasks and no other tasks. The three Execute SQL tasks modify products in
staging tables in preparation for a data warehouse load.
The package and all three Execute SQL product tasks have their TransactionOption property
set to Supported.
You need to ensure that if any of the three Execute SQL product tasks fail, all three tasks will
roll back their changes.
What should you do?
Which four actions should you perform in sequence by using SQL Server Management Studio?
DRAG DROP
You are developing a SQL Server Integration Services (SSIS) project by using the Project
Deployment model.
The project contains many packages. It is deployed on a server named SQLTest1. The
project will be deployed to several servers that run SQL Server 2012.
The project accepts one required parameter. The data type of the parameter is a string.
A SQL Agent job is created that will call the Loading.dtsx package in the project. A job step
is created for the SSIS package.
The job must pass the value of an SSIS Environment Variable to the project parameter. The
value of the Environment Variable must be configured differently on each server that runs
SQL Server. The value of the Environment Variable must provide the server name to the
project parameter.
You need to configure SSIS on the SQLTest1 server to pass the Environment Variable to the
package.
Which four actions should you perform in sequence by using SQL Server Management
Studio?
(To answer, move the appropriate actions from the list of actions to the answer area and
arrange them in the correct order.)