black

MCTS(70-432)

单项选择题

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. On DB1, quite few logged operations are performed. Now according to the requirement of the company CIO, you must validate that the database can be restored to a specific point in time. So what action should you perform to achieve this goal? （） 

A.You should verify that the simple recovery model is used by the database.
B.You should verify that the full recovery model is used by the database.
C.You should verify that the checksum page verify option is used by the database. 
D.You should verify that the bulk-logged recovery model is used by the database. 

相关考题

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Thereisacomputerwhichhostsseveralapplicationsinyourcompany.Theinstancerunsonthecomputer.AjobnamedDiliveryListiscreatedbyyou.Thisjobrequiresafiletobewrittentoafileserver.Butbecausethejobcannotaccessthefileserver,itfailstorun.YouintendtoconfiguretheSQLServerAgentservicesothatonlytheSQLServerAgentservicehasreadandwriteaccesstothefileserver.Whichaccounttypeshouldyouuse?（）

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064