找考题网-背景图
单项选择题

YouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Therearequeriesthathaveanestimatedexecutioncostlessthan3.Youintendtoconfiguretheinstance,makeituseasinglethreadforthesequeries.Intheoptionsbelow,whichsp_configureconfigurationoptionshouldyouset?()
A.Youshouldsetquerygovernorcostlimit
B.Youshouldsetcostthresholdforparallelism
C.Youshouldsetpriorityboost
D.Youshouldsetprecomputerank

A.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Therearequeriesthathaveanestimatedexecutioncostlessthan3.Youintendtoconfiguretheinstance,makeituseasinglethreadforthesequeries.Intheoptionsbelow,whichsp_configureconfigurationoptionshouldyouset?()
A.Youshouldsetquerygovernorcostlimit
B.Youshouldsetcostthresholdforparallelism
C.Youshouldsetpriorityboost
D.Youshouldsetprecomputerank
热门试题

单项选择题YournetworkconsistsofWindowsXPcomputers.AllcomputersarejoinedtoasingleActiveDirectorydirectoryservicedomainandlocatedinasingleActiveDirectorysite.YoucreateanewGroupPolicyobject(GPO)andlinkittothesite.Thepolicyconfiguresdefaultscreensaversettings.Useraccountsofusersintheresearchdepartmentarelocatedinanorganizationalunit(OU)namedResearch.Youneedtoallowusersintheresearchdepartmenttoconfigureadifferentscreensaversettingontheircomputers.Whatshouldyoudo?()A.MovetheuseraccountsofusersintheresearchdepartmenttotheUserscontainer.B.Configurealocalsecuritypolicyonallcomputersintheresearchdepartmenttoallowuserstomodifytheirscreensaversettings.C.Addusersintheresearchdepartmenttoadomaingroup.AllowthegrouptheApplyGroupPolicypermissionfortheGPO.D.Addusersintheresearchdepartmenttoadomaingroup.DenythegrouptheApplyGroupPolicypermissiontotheGPO.

A.AllcomputersarejoinedtoasingleActiveDirectorydirectoryservicedomainandlocatedinasingleActiveDirectorysite.YoucreateanewGroupPolicyobject(GPO)andlinkittothesite.Thepolicyconfiguresdefaultscreensaversettings.Useraccountsofusersintheresearchdepartmentarelocatedinanorganizationalunit(OU)namedResearch.Youneedtoallowusersintheresearchdepartmenttoconfigureadifferentscreensaversettingontheircomputers.Whatshouldyoudo?()
A.MovetheuseraccountsofusersintheresearchdepartmenttotheUserscontainer.
B.Configurealocalsecuritypolicyonallcomputersintheresearchdepartmenttoallowuserstomodifytheirscreensaversettings.
C.Addusersintheresearchdepartmenttoadomaingroup.AllowthegrouptheApplyGroupPolicypermissionfortheGPO.
D.Addusersintheresearchdepartmenttoadomaingroup.DenythegrouptheApplyGroupPolicypermissiontotheGPO.