多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

TestKing.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins.You need to write a distributed query that joins the data on SQL1 with the data on SQL2. What should you do?()

  • A、Ensure that both SQL1 and SQL2 use the same login name as the security context for each server.
  • B、Configure SQL2 as a remote server. Write the query on SQL1.
  • C、Configure SQL2 as a linked server to impersonate the remote login.
  • D、Configure SQL2 as a distributed server. Use pass-through authentication.
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题