Youareadatabaseadministratorforyourcompany.Adatabaseononeofthecompany’sSQLServer2005computersstorestransactioninformationforthecompany’sWeb-basedordersystem.Thedatabaseisconfiguredtousethefullrecoverymodel.Yourcompanyreceivesveryfewordersbetweenthehoursof19：00and04：00.Yourmaximumacceptableriskfordatalossisonehour.Databasebackupsmustbeperformedasquicklyaspossible.Youneedtodevelopamaintenanceplantomanagethisrisk.Whatshouldyoudo？（）A.Configure a Back Up Database task to do a full backup of the database every hour.Configure a Check Database Integrity task to run every hour.B.Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a third Back Up Database task to do transaction log backups every hour.C.Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a Check Database Integrity task to run every hour.D.Configure a Back Up Database task to do a full backup at 09：00 and 14：00.Configure a second Back Up Database task to do transaction log backups every hour.

单项选择题

You are a database administrator for your company. A database on one of the company’s SQL Server 2005 computers stores transaction information for the company’s Web-based order system. The database is configured to use the full recovery model. Your company receives very few orders between the hours of 19：00 and 04：00. Your maximum acceptable risk for data loss is one hour. Database backups must be performed as quickly as possible. You need to develop a maintenance plan to manage this risk. What should you do？（）

A.Configure a Back Up Database task to do a full backup of the database every hour.Configure a Check Database Integrity task to run every hour.
B.Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a third Back Up Database task to do transaction log backups every hour.
C.Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a Check Database Integrity task to run every hour.
D.Configure a Back Up Database task to do a full backup at 09：00 and 14：00.Configure a second Back Up Database task to do transaction log backups every hour.

MCITP(70-444)