单项选择题
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.
相关考题
-
单项选择题
YouareadatabaseadministratoroftwoSQLServer2005computersnamedSQL1andSQL2.YouhaveaMicrosoft.NETapplicationthathasbeenmodifiedsothatitnowaccessesadatabaseonSQL2inadditiontoSQL1.YoudonotwanttheuserapplicationtoconnectdirectlytoSQL2.YouneedtoenablethedataretrievalfromSQL2whilemaintainingtheabilitytoassigndifferentpermissionstodifferentuserswhousethe.NETapplication.Whatshouldyoudo?()
A.Change the .NET application to define a new server connection to SQL2.
B.Configure a linked server on SQL1 to point to SQL2.
C.Configure a linked server on SQL2 to point to SQL1.
D.Change the stored procedures called by the .NET application to include the OPENXML command. -
单项选择题
Youareadatabaseadministratorforyourcompany.ThecompanyusesaSQLServer2005database.Afullbackupofthedatabaseismadeeachnight.Transactionlogbackupsaremadeeachmorningandeachafternoon.Younoticethatthedatabasetransactionlogfilegrowsverylargethroughouttheday.Youneedtominimizethesizeofthetransactionlogfile.Youalsoneedtominimizedatalossintheeventofafailure.Whatshouldyoudo?()
A.Decrease the amount of time between transaction log backups.
B.Configure the database to use the simple recovery model.
C.Configure the RECOVERY INTERVAL option to be a smaller value.
D.Run DBCC SHRINKFILE on the transaction log file. -
单项选择题
Youareadatabaseadministratorforyourcompany.YouareresponsibleforaSQLServer2005databasethathasseveralindexes.Youneedtowriteastoredprocedurethatcheckstheindexesforfragmentation.WhichTransact-SQLstatementshouldyouuse?()
A.DBCC DBREINDEX
B.SELECT * FROM sys.dm_db_index_physical_stats
C.DBCC INDEXDEFRAG
D.SELECT * FROM sys.indexes
