单项选择题
You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do？（）
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 -
多项选择题
Youareadatabaseadministratorforyourcompany.YouareconfiguringanewSQLServer2005computernamedSQL1.SQL1willrunReportingServices.Itwillalsobeconfiguredtoautomaticallyperformdatabasebackupsandothermaintenancetasks.TherearenootherSQLServercomputersinthenetworkenvironment.AllaccesstoSQL1willbemadebyusingSQL1sDNSname.YouneedtodisableanyunnecessaryservicesonSQL1.Whichserviceorservicesshouldyoudisable？（）
A.Internet Information Services
B.SQL Server Browser
C.SQL Server Agent
D.Microsoft Distributed Transaction Coordinator -
多项选择题
Youareadatabaseadministratorforyourcompany.Thecompanyrunsapopulardatabase-drivenWebsiteagainstaSQLServer2005computernamedSQL2.YouneedtoensureaquickresponsetimeandappropriateaudittrailintheeventthatSQL2experiencesexcessivetrafficduetodenial-of-service（DoS）attacks.Whichtwoactionsshouldyouperform？（）
A.Create a new performance alert to monitor the Current Bandwidth counter.
B.Create a new performance alert to monitor the Bytes Total/sec counter.
C.Configure the new performance alert to start a SQL Server Profiler trace.
D.Configure the new performance alert to start a Network Monitor capture.
