Question 14

Answer C is correct. You must have a linked server defined at the location at which you are executing the query. A remote server is antiquated technology that should not be used and is not supported for use in SQL Server 2005. An alias does not help the situation; it only provides for another name. Four-part names do not work if no linked server is defined.

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