Domain.com has employed you as a database administrator. The Domain.com network consists of a single Active Directory domain named Domain.com. You have been informed by the CIO that your application should access data that is located on two SQL Server 2005 computers. The two SQL Servers are named Certkiller -DB02 and Certkiller -DB03. The CIO informs you that you have the permissions to create a stored procedure on Certkiller -DB02 to support the application. However, on Certkiller -DB03, you only have permissions to select data.
A Domain.com user named Andy Reid is a member of the Research and Development department. You instruct Andy Reid to write the stored procedure on Certkiller -DB02. The stored procedure accesses Certkiller -DB03 by using the OPENQUERY Transact-SQL statement. Andy Reid discovers that the query fails when it is executed. Andy Reid needs to troubleshoot the origin of the error.
What should he do?
A.
Andy Reid needs to add Certkiller -DB03 as a remote server to Certkiller -DB02.
B.
By making use of the four-part syntax of server database schema table Andy Reid should join the two servers.
C.
Andy Reid should add Certkiller -DB03 as a linked server to Certkiller -DB02.
D.
By using an alias Andy Reid should reference Certkiller -DB03.
Explanation:
A linked server needs to be defined for every external data source you want to access. The security context needs to be configured under which the distributed queries will run. After creating a linked server you can make use of the Transact-SQL OPENQUERY function to execute the distributed queries.