Microsoft Exam Questions

You have recently removed a SQL 2012 Database Engine instance from a computer running the Windows Se

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?

A. ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = AUTO

B. ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 2,3

C. ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 0,1

D. ALTER SERVER CONFIG

URATION SET PROCESS AFFINITY CPU = 0,4