You are a database administrator for AIOTestKing.com. The company has two SQL Server 2005 computers named AIOTestKing A and AIOTestKing B. AIOTestKing A is located on the local network. AIOTestKing B is located at a vendors site and is connected by using a VPN over the Internet. You need to write heterogeneous queries on AIOTestKing A that access data from both AIOTestKing A and AIOTestKing B. To ensure that your queries are functional, you must configure access to the vendors site. What should you do?
A.
Configure an HTTP endpoint for AIOTestKing A on AIOTestKing B.
B.
Configure AIOTestKing B as a linked server on AIOTestKing A.
C.
Configure AIOTestKing A as a linked server on AIOTestKing B.
D.
Configure an HTTP endpoint for AIOTestKing B on AIOTestKing A.
Explanation:
A linked server is used to execute queries over multiple SQL Servers. AIOTestKing B should be created as a linked server on AIOTestKing A as it is AIOTestKing A that will execute the query.