YouareadatabaseadministratoroftwoSQLServer2005computersnamedSQL1andSQL2.YouhaveaMicrosoft.NETapplicationthathasbeenmodifiedsothatitnowaccessesadatabaseonSQL2inadditiontoSQL1.YoudonotwanttheuserapplicationtoconnectdirectlytoSQL2.YouneedtoenablethedataretrievalfromSQL2whilemaintainingtheabilitytoassigndifferentpermissionstodifferentuserswhousethe.NETapplication.Whatshouldyoudo？（）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.

单项选择题

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.

MCITP(70-444)