A.You should set query governor cost limitB.You should ……

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.DB1isavailabletoaWindowsgroupwhichisnamedWIIKIGO Supervisors.AWindowsusernamedUser1isamemberoftheWIIKIGO Supervisorsgroup.WIIKIGO Supervisorsisamemberofthedb_ownerroleintheDB1database.YoumustmakesurethattheSQLServerinstanceisavailabletoUser1.IntheDB1database,whichTransact-SQLstatement(s)shouldyouexecute?（）

A. DROP LOGIN "WIIKIGO\User1"; 
B. EXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO\User1';
C. EXEC dbo.sp_revokedbaccess 'WIIKIGO\User1';EXEC dbo.sp_revokelogin 'WIIKIGO\User1'; 
D. CREATE LOGIN "WIIKIGO\User1" FROM Windows;DENY CONNECT SQL TO "WIIKIGO\User1";

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.DB1hasatablewhichisnamedTable01andastoredprocedurenamedProcedure01.Procedure01choosedatafromTable01byusingasp_executesqlTransact-SQLstatement.Youcompanysecurityrulesforbiduserstoaccesstablesdirectlyinanydatabase.Lookattheexceptionbelow: Msg229,Level14,State5,Line1TheSELECTpermissionwasdeniedontheobject'Table01',database 'DB1',schema'dbo'. TheexceptionisraisedwhenProcedure01isexecutedbyusers.YoumustmakesurethateusercansuccessfullyexecuteProcedure1complyingwiththecompanyrules.Sowhatactionshouldyouperformtoachievethisgoal?（）

A.You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement. 
B.You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement. 
C.You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header 
D.You should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure.

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisatextfilewhichisnamedSQL01.logontheE:drive.ASQLServerAgentjobexecutesevery2minutesandlogsinformationtothetextfile.Yougetareportfromuserssayingthattheseverdoesn'tmakeresponse.Asthetechnicalsupport,youcheckandfindthattheSQLServerAgentservicedoesnotrunandtheSQLServerAgentjobnolongerfunctions.YouhavetoidentifythereasonwhytheSQLServerAgentserviceisunresponsive.Intheoptionsbelow,whichlogshouldyoucheck?（）

A.You should check SQL1.log
B.You should check SQLAGENT.OUT
C.You should check log_xx.trc
D.You should check ERRORLOG

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedServiceintheinstance.ThereisadatabaseuserwhoisnamedServiceGreatUser.ASQLServerloginnamedServiceGreatLoginmapstoServiceGreatUserintheServicedatabase.AccordingtotherequirementofthecompanyCIO,thedatabaseusercanonlyperformthetwotasksbelow:thedatabaseuserexecutesallstoredproceduresthatcurrentlyexistintheSalesdatabaseandexecutesallstoredproceduresthatwillbecreatedintheSalesdatabase.Sowhatshouldyoudotoensurethis?（）

A.ServiceGreatUser should be added to the appropriate fixed database roles. 
B.You should assign the appropriate object-level permissions to ServiceGreatUser 
C.You should assign the appropriate server-level permissions to ServiceGreatLogin 
D.You should assign the appropriate database-level permissions to ServiceGreatUser

单项选择题YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisaninternalapplicationwhichusesAnalysisServicesandReportingServices.YouusetheapplicationonthebasisofSQLServer2008.Accordingtotherequirementofcompanysecuritypolicy,thesurfaceareaforallthedeployedcomponentsofSQLServer2008shouldbeconfigured.Youhavetoimplementthesecuritypolicyanddeviseamethodtoevaluatethesecuritypolicyagainstotherdatabaseservers.Whatshouldyoudo?（）

A.You should create policies based on the appropriate facets. Apply the policies against a server group. The server group includes the database servers that need to be configured 
B.You should create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to run the script against a server group that includes the database servers that need to be configured 
C.You should edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured 
D.You should analyze your database servers by using the SQL Server Best Practices Analyzer (BPA). Implement the recommendations of the BPA