Which of the following features must you install on the ETL server in addition to SSIS to accomplish this goal
You are planning on deploying a server that will be dedicated for ETL (Extraction, Transformation,
and Loading) processes.
You want to ensure that SSIS (SQL Server Integration Services) packages will run on this dedicated
ETL server and not on any other server on which they were started.
Which of the following features must you install on the ETL server in addition to SSIS to accomplish
this goal?
Which of the following features must you install if you want to ensure that you can run packages in 32-bit mod
You have installed the SQL Server Integration Services (SSIS) feature on a server running Windows
Server 2008 R2 SP1.
Which of the following features must you install if you want to ensure that you can run packages in
32-bit mode?
Which of the following files will you generate by using SQL Server Setup to accomplish this goal?
You want to reproduce the same SQL Server 2012 installation configuration across five servers.
Which of the following files will you generate by using SQL Server Setup to accomplish this goal?
Which of the following tools can you use to accomplish this goal?
You want to remove SQL Server Integration Services from a server running the Windows Server 2008
R2 operating system that also has the Database Engine and SQL Server Analysis Services installed.
Which of the following tools can you use to accomplish this goal?
Which of the following commands would you use to accomplish this goal?
You have recently removed a SQL 2012 Database Engine instance from a computer running the
Windows Server 2008 R2 operating system. Prior to the removal of the instance, you had configured
affinity so that the default instance used CPU 0 and 1 and the second instance used CPU 2 and 3.
You want to ensure that the default instance can use all processors available to the host.
Which of the following commands would you use to accomplish this goal?
Which feature should you enable and configure so session requests addressed…?
Which feature should you enable and configure so session requests addressed to a specific instance
can be allocated different processor resources based on session request properties?
What is the maximum CPU and memory value you can assign to this resource pool?
You have configured Resource Governor with three resource pools.
You have assigned the first resource pool a minimum CPU and memory value of 20%.
You have assigned the second resource pool a minimum CPU and memory value of 30%.
You want to assign maximum CPU and memory values to the third resource pool.
What is the maximum CPU and memory value you can assign to this resource pool?
which of the following operating systems can you deploy the 64-bit version of SQL Server 2012 Enterprise editi
On which of the following operating systems can you deploy the 64-bit version of SQL Server 2012
Enterprise edition? (Choose all that apply.)
Which of the following editions of SQL Server 2012 can you run on a computer that is running the Windows 7 Pro
Which of the following editions of SQL Server 2012 can you run on a computer that is running the
Windows 7 Professional (x64) operating system? (Choose all that apply.)
Which of the following features can you install if you are installing SQL Server 2012…?
Which of the following features can you install if you are installing SQL Server 2012 Enterprise
edition on a computer running Windows Server 2008 R2 SP1 Enterprise edition in the Server Core
configuration? (Choose all that apply.)