单项选择题

You need to configure Active Directory to implement the new password policy for the HR department. What should you do？（）

A.Create a new child domain named hr.ad.margiestravel.com in the existing forest. Move the resources from the HR OU to this new domain. Add the appropriate security settings in the Default Domain Policy for this new domain.
B.Add the appropriate security settings to the current Default Domain Policy.
C.Add the appropriate security settings to the local security policy of SQL1.
D.Set the SQL server check_policy and check_expiration options to On when creating all user accounts.

<上一题目录下一题>

热门试题

单项选择题YouneedtoimplementanauthenticationmethodonSQL4.TheTravelOnlinedatabasewillbeaccessedthroughaWebservicesapplication.Youneedtomaketheauthenticationmethodassecureaspossible.Whatshouldyoudo？（）

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.

多项选择题Youneedtoensurethatthecompany’sstandardpasswordpolicyisenforcedforallloginsthatareusedtoaccessSQLServer2005.Whichtwoactionsshouldyouperform？（）

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.

多项选择题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.

单项选择题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.

单项选择题YouneedtodesignahostingserviceoptionforcustomerswhowanttoaccesstheirdatabasesbyusingtheirownActiveDirectorydomainaccounts.Whatshouldyoudo？（）

A.Design a hosting service option that duplicates each customer’s domain user account as SQL Serverlogin account.
B.Design a hosting service option that provides VPN-based connectivity from each customer’s network tothe SQL Server computer that hosts that customer’s daabase or databases.
C.Design a hosting service option that provides a dedicated server to each customer.Join that server to that customer’s Active Directory domain
D.Design a hosting service option that configures a unique instance of SQL Server 2005 for each customer.Configure that instance to use Integrated Windows authentication.