Which three actions should you perform in sequence?
A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog. The project
includes a project Connection Manager to connect tothe data warehouse. The SSIS catalog includes
two Environments:
Development
QA
Each Environment defines a single Environment Variable named ConnectionString of type string. The
value of each variable consists of the connection string to the development or QA data warehouses.
You need to be able to execute deployed packages byusing either of the defined Environments.
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.)
Which three actions should you perform in sequence?
You are validating whether a SQL Server IntegrationServices (SSIS) package named Master.dtsx in the SSIS
catalog is executing correctly. You need to displaythe number of rows in each buffer passed between each
data flow component of the package. Which three actions should you perform in sequence? (To answer, move
the appropriate actions from the list of actions tothe answer area and arrange them in the correct order.) 
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 typeof 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 serverthat
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.)
Which three actions should you perform in sequence?
DRAG DROP
A Data Flow task in a SQL Server Integration Services (SSIS) package produces run- time errors. You need to
edit the package to log specific error messages. 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.)
Which three actions should you perform in sequence?
You plan to deploy a SQL Server Integration Services (SSIS) project by using the project deployment model.
You need to monitor control flow tasks to determinewhether any of them are running longer than usual.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 be able to start the SQL Server
You administer a Microsoft SQL Server 2012 instance.
After a routine shutdown, the drive that contains tempdb fails.
You need to be able to start the SQL Server. What should you do?
You need to ensure that the application login is unable to access other production databases
You administer a single server that contains a Microsoft SQL Server 2012 default instance.
You plan to install a new application that requiresthe deployment of a database on the server.
The application login requires sysadmin permissions.
You need to ensure that the application login is unable to access other production databases. What should you
do?
What should you configure?
You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores.
You discover performance issues when large amounts of data are written to tables under heavy system load.
You need to limit the number of cores that handle I/O.
What should you configure?
You need to ensure that if the Finance department disapproves the batch process, the batch operation can be ro
You administer a Microsoft SQL Server 2012 instancenamed SQL2012 that hosts an OLTP database of 1
terabyte in size.
The database is modified by users only from Monday through Friday from 09:00 hours to 17:00 hours.
Users modify more than 30 percent of the data in the database during the week. Backups are performed as
shown in the following schedule:
The Finance department plans to execute a batch process every Saturday at 09:00 hours.
This batch process will take a maximum of 8 hours to complete.
The batch process will update three tables that are10 GB in size.
The batch process will update these tables multipletimes.
When the batch process completes, the Finance department runs a report to find out whether the batch
process has completed correctly.
You need to ensure that if the Finance department disapproves the batch process, the batch operation can be
rolled back in the minimum amount of time.
What should you do on Saturday?
You need to ensure that the following requirements are met: No more than 5 minutes worth of transactions are l
You administer a Microsoft SQL Server 2012 instance.
The instance contains a database that supports a retail sales application.
The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per
week.
You plan to define a backup strategy for the database.
You need to ensure that the following requirements are met:
No more than 5 minutes worth of transactions are lost.
Data can be recovered by using the minimum amount of administrative effort.
What should you do? Choose all that apply.