单项选择题

Youneedtospecifythechangestotheexistingfirewallconfigur……

You need to specify the changes to the existing firewall configuration settings that are required by the HTTP endpoint that will be used by the proseware_projects database. What should you do？（）

A.Create a Web publishing rule on ISA2 that allows HTTP traffic on port 5017 from IIS1 to the SQL Server computer.
B.Create a Web publishing rule on ISA1 that allows HTTP traffic on port 5017 from IIS1 to the SQL Server computer.
C.Create a Web publishing rule on ISA2 that allows HTTPS traffic on port 5017 from IIS1 to the SQL Server computer.
D.Create a Web publishing rule on ISA1 that allows HTTPS traffic on port 5017 from IIS1 to the SQL Server computer.

<上一题目录下一题>

热门试题

单项选择题Youneedtodefineanauthenticationsystemforthemainofficedatabaseadministrators.Thesetupshouldrequiretheminimumamountofadministrativeeffort.Theauthenticationenvironmentmustfulfillthecompany’ssecurityrequirements.Whatshouldyoudo？（）

A.Create a SQL Server login with Windows Authentication for each main office database administrator.Add all of these logins to the db_owner role in each database.
B.Create a SQL Server login with SQL Server Authentication for each main office database administrator.Add all of these logins to the sysadmin role.
C.Create a Windows global group named DBAdmins. Add each main office database administrator’s Windows user account to the Windows DBAdmins group.Create a SQL Server login with Windows Authentication for the group.Add the group to the serveradmin fixed server role.
D.Add each main office database administrator’s Windows user account to the Windows SQLManagersgroup.

单项选择题YouneedtoconfigureActiveDirectorytoimplementthenewpasswordpolicyfortheHRdepartment.Whatshouldyoudo？（）

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.