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 to a specific instance
can be allocated different processor resources based on session request properties?

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?

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 Professional (x64) operating system? (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 apply.)

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.
Which of the following tools would you use to accomplish this goal?

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?