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

微软认证考试

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

You are a database administrator of two SQL Server 2005 computers named SQL1 and SQL2. You have a Microsoft .NET application that has been modified so that it now accesses a database on SQL2 in addition to SQL1. You do not want the user application to connect directly to SQL2. You need to enable the data retrieval from SQL2 while maintaining the ability to assign different permissions to different users who use the .NET application. What should you do?()

  • A、Change the .NET application to define a new server connection to SQL2.
  • B、Configure a linked server on SQL1 to point to SQL2.
  • C、Configure a linked server on SQL2 to point to SQL1.
  • D、Change the stored procedures called by the .NET application to include the OPENXML command.
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题