试题详情
- 单项选择题 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 foreach 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
关注下方微信公众号，在线模考后查看
热门试题