PrepAway - Latest Free Exam Questions & Answers

What should you do?

You work as DBA at AIOTestKing.com. You administer two SQL Server 2005 computers named AIOTestKing A and AIOTestKing B. You were not responsible for the original installation of SQL Server on these computers. Yet you now must ensure that both computers are configured according to the following requirements. Administrators must be able to remotely connect to AIOTestKing A and AIOTestKing B for troubleshooting, even if the system becomes unresponsive. AIOTestKing A and AIOTestKing B must not be able to execute commands related to the operating system.Database access must be permitted by using Simple Object Access Protocol (SOAP) messages over HTTP. AIOTestKing A and AIOTestKing B must not be able to use stored procedures to send e-mail.Use of the OPENROWSET and OPENDATASOURCE Transact-SQL statements must not be permitted.Stored procedures for generating HTML must not be permitted. You need to configure AIOTestKing A and AIOTestKing B to meet these requirements. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Use SQL Server Surface Area Configuration for Features.

B.
Use SQL Server Configuration Manager to configure the appropriate server features on AIOTestKing A and AIOTestKing B.

C.
Use SQL Server Surface Area Configuration for Services and Connections.

D.
Use the sp_configure system stored procedure to configure the appropriate server features on AIOTestKing A and AIOTestKing B.

Explanation:
Use SQL Server Surface Area Configuration to enable, disable, start, or stop the features, services, and remote connectivity of your SQL Server 2005 installations. You can use SQL Server Surface Area Configuration on local and remote servers.


Leave a Reply