YouareconfiguringSQL1sothatthedistributedqueryintheSalesdatabasecanaccessdataintheCRMdatabaseonSQL2.YoucreatealinkedserverforSQL2，andyoucreatealinkedserverloginthatusesimpersonation.Now，youneedtoaskthenetworkadministratortoconfigureSQL1.Whichtwotasksshouldyouasktheadministratortoperform？（）A.Add the user account that is used by the SQL Server service to the local Administrators group.B.Enable the Do not trust this user for delegation Active Domain property for the user account that is used by the SQL Server service.C.Create a Service Principal Name （SPN） for the user account that is used by the SQL Server service.D.Enable the Trusted for delegation Active Domain property for the user account that is used by the SQL Server service.

多项选择题

You are configuring SQL1 so that the distributed query in the Sales database can access data in the CRM database on SQL2. You create a linked server for SQL2， and you create a linked server login that uses impersonation.Now， you need to ask the network administrator to configure SQL1. Which two tasks should you ask the administrator to perform？（）

A.Add the user account that is used by the SQL Server service to the local Administrators group.
B.Enable the Do not trust this user for delegation Active Domain property for the user account that is used by the SQL Server service.
C.Create a Service Principal Name （SPN） for the user account that is used by the SQL Server service.
D.Enable the Trusted for delegation Active Domain property for the user account that is used by the SQL Server service.

MCITP(70-443)