单项选择题
A.You should set query governor cost limit
B.You should set cost threshold for parallelism
C.You should set priority boost
D.You should set precompute rank
单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.DB1isavailabletoaWindowsgroupwhichisnamedWIIKIGO\Supervisors.AWindowsusernamedUser1isamemberoftheWIIKIGO\Supervisorsgroup.WIIKIGO\Supervisorsisamemberofthedb_ownerroleintheDB1database.YoumustmakesurethattheSQLServerinstanceisavailabletoUser1.IntheDB1database,whichTransact-SQLstatement(s)shouldyouexecute?（）
单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.DB1hasatablewhichisnamedTable01andastoredprocedurenamedProcedure01.Procedure01choosedatafromTable01byusingasp_executesqlTransact-SQLstatement.Youcompanysecurityrulesforbiduserstoaccesstablesdirectlyinanydatabase.Lookattheexceptionbelow:"Msg229,Level14,State5,Line1TheSELECTpermissionwasdeniedontheobject'Table01',database 'DB1',schema'dbo'."TheexceptionisraisedwhenProcedure01isexecutedbyusers.YoumustmakesurethateusercansuccessfullyexecuteProcedure1complyingwiththecompanyrules.Sowhatactionshouldyouperformtoachievethisgoal?（）
单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisatextfilewhichisnamedSQL01.logontheE:drive.ASQLServerAgentjobexecutesevery2minutesandlogsinformationtothetextfile.Yougetareportfromuserssayingthattheseverdoesn'tmakeresponse.Asthetechnicalsupport,youcheckandfindthattheSQLServerAgentservicedoesnotrunandtheSQLServerAgentjobnolongerfunctions.YouhavetoidentifythereasonwhytheSQLServerAgentserviceisunresponsive.Intheoptionsbelow,whichlogshouldyoucheck?（）