Question 15

Answer E is correct. If you are using two servers with different logins, you can easily map them by using the linked-server configuration properties. Logins on one server in this manner can impersonate logins on another server. Hard-coding the user ID and password and/or using the sa user ID and password are both problematic in performing updates and are potential security risks.

For more information, see the following sources:

• Chapter 1, "Installing and Configuring SQL Server 2005"

• SQL Server 2005 Books Online: "SQL Server Database Engine, Administering the Database Engine, Managing Servers, Linking Servers"

• "Configuring Linked Servers," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp