You want to remove SQL Server Integration Services from a server runni…

You have recently removed a SQL 2012 Database Engine instance from a computer running the Windows Server 2008 R2 operating system. Prior to the…

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?

You have configured Resource Governor with three resource pools.

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 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 appl…

What is the minimum recommended amount of RAM for SQL Server 2012 Enterprise?

You want to simulate read, write, checkpoint, backup, sort, and read-ahead activities for your organization-s SQL Server 2012 deployment.

What is the maximum number of SQL Server 2012 Enterprise edition Database Engine instances that you can deploy on a non-clustered server running Windows Server 2008 R2 Enterprise edition?

You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the…