试题详情
单项选择题You are a database administrator for your company. The company has two SQL Server 2005 computers named SQL1 and SQL2. SQL1 is located on the local network. SQL2 is located at a vendors site and is connected by using a VPN over the Internet. You need to write heterogeneous queries on SQL1 that access data from both SQL1 and SQL2. 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 SQL2 on SQL1.

B、Configure SQL2 as a linked server on SQL1.

C、Configure an HTTP endpoint for SQL1 on SQL2.

D、Configure SQL1 as a linked server on SQL2.

  • B
  • 关注下方微信公众号,在线模考后查看

热门试题