单项选择题

You need to implement an authentication method on SQL4. The TravelOnline database will be accessed through a Web services application. You need to make the authentication method as secure as possible.What should you do？（）

A.Create an HTTP endpoint with NTLM authentication， and create a service principal name （SPN）.
B.Create an HTTP endpoint with digest authentication， and create a service principal name （SPN）.
C.Create an HTTP endpoint with integrated authentication， and create a service principal name （SPN）.
D.Create an HTTP endpoint with Kerberos authentication.

点击查看答案

上一题目录下一题

相关考题

多项选择题

You need to ensure that the company’s standard password policy is enforced for all logins that areused to access SQL Server 2005.Which two actions should you perform？（）

A.Set the appropriate local password policies for all computers on which SQL Server is installed.
B.Set the server authentication mode of all SQL Server instances to Windows Authentication mode.
C.Install all instances of SQL Server 2005 on computers that run Windows Server 2003 or later.
D.Create SQL Server logins that have CHECK_POLICY enabled.

多项选择题

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.

单项选择题

There are currently no permissions set on the following four objects in the proseware_biz database：

You need to permit the sales_employee database role to retrieve data by using the Sales.GetContact stored procedure.
Which action or actions should you perform？（）

A.Grant the SELECT permission on the Sales.Customers object to the sales_employee role.
B.Grant the SELECT permission on the Sales.CustomerContacts object to the sales_employee role.
C.Grant the SELECT permission on the Sales.ContactList object to the sales_employee role.
D.Grant the EXECUTE permission on the Sales.GetContact object to the sales_employee role.