Which Transact-SQL script must you run on all three servers?

You are the SQL administrator for your company. You have three SQL Server 2008 computers named SQL1 , SQL2 , and SQL3 . Each server supports a single instance.
You have been asked to configure SQL1 to connect to remote data sources that use OLE DB. You have alsobeen asked to configure SQL2 to control CPU usage and to configure SQL3 to provide access to physicalmemory. Which Transact-SQL script must you run on all three servers?

A.
sp_configure ‘ad hoc distributed queries’, 1;
GO
RECONFIGURE;
GO

B.
sp_configure ‘awe enabled’, 1;
GO
RECONFIGURE;
GO

C.
sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO

D.
SELECT * FROM sys.configurations
ORDER BY name;
GO

Explanation:

You must run the following Transact-SQL script on all three servers:
sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO

In this scenario, all three servers require the configuration of advanced options, which should only be changed byan experienced database administrator. Before you can change advanced options, you must use sp_configure to set the show advanced options configuration option to a value of 1.
You should not run the following Transact-SQL script on all three servers:
sp_configure ‘ad hoc distributed queries’, 1;
GO
RECONFIGURE;
GO

The ad hoc distributed queries configuration option configures a server to connect to remote database sourcesthat use OLE DB. This script should be run on SQL1 after running the script that configures the show advancedoptions option. You should not run the following Transact-SQL script on all three servers:
sp_configure ‘awe enabled’, 1;

GO
RECONFIGURE;
GO
The awe enabled configuration option configures a server to use physical memory. This allows the data cache toexpand to the amount of available physical memory, instead of being limited to the size of the virtual memory.This script should be run on SQL3 after running the script that configures the show advanced options option.You can also configure this setting from the Memory page of the SQL server’s Server Properties dialog box byselecting the Use AWE to allocate memory check box. The Memory page of the SQL server’s ServerProperties dialog box is shown in the following image:

You should not run the following Transact-SQL script on all three servers:
SELECT * FROM sys.configurations
ORDER BY name;
GO

This script displays information for each configuration option you can pass to the sp_configure system storedprocedure. It is not necessary to view these settings to change them.
To configure SQL2 to control CPU usage, you would use the affinity I/O mask and affinity mask optionsand the affinity64 I/O mask and affinity64 mask options (on a server with more than 32 processorsrunning the 64-bit version of SQL Server).
For example, in this scenario, after running the script to set the show advanced options configuration option, you could run the following script on SQL2 to set the affinitymask
configuration option:
sp_configure ‘affinity mask’, 38;
RECONFIGURE;
GO

You can also manage these options using the SQL Server Management Studio.

Objective:
Installing and Configuring SQL Server 2008

Sub-Objective:
Configure SQL Server instances.

References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration > ManagingServers > Setting Server Configuration Options