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,"

MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: