black

MCITP(70-444)

单项选择题

You are a database administrator for your company. The company’s financial forecasting application uses a SQL Server 2005 database that enables business users to run both ad hoc and predefined queries. You suspect that some queries consume an excessive amount of server resources. You need to identify which queries consume the most resources. You want to achieve this goal as quickly as possible. What should you do？（）

A.Use the DBCC INPUTBUFFER command.
B.Use the sys.dm_exec_query_stats dynamic management view （DMV）.
C.Use the sqldiag utility.
D.Use the SHOWPLAN session option.

相关考题

单项选择题 YouaretheadministratorofaSQLServer2005computernamedSQL1.SQL1containsadatabasethatutilizesSQLServerlogshipping.Logshippingoccursevery30minutes.Eachnight，afullbackupismadeofthedatabase，andalldatabaseindexesarerebuilt.Thecompany’snetworkadministratorreportsthatSQL1snetworkutilizationbecomesexcessiveafterthenightlymaintenancetasksarecomplete.YouneedtoreducethenetworkbandwidthutilizationforSQL1.Whatshouldyoudo？（）

单项选择题 Youareadatabaseadministratorforyourcompany.Eachnight，youperformfullbackupsofyourSQLServer2005computer.Duringbusinesshours，youperformhourlytransactionlogbackups.Yourebuilddatabaseindexeseachnight.Youneedtomodifyyourbackupstrategy.Youmustensurethatthedatabaserecoverstoanewserverasquicklyaspossible.Whatshouldyoudo？（）

单项选择题 Youareadatabaseadministratorforyourcompany.Adatabaseononeofthecompany’sSQLServer2005computersstorestransactioninformationforthecompany’sWeb-basedordersystem.Thedatabaseisconfiguredtousethefullrecoverymodel.Yourcompanyreceivesveryfewordersbetweenthehoursof19：00and04：00.Yourmaximumacceptableriskfordatalossisonehour.Databasebackupsmustbeperformedasquicklyaspossible.Youneedtodevelopamaintenanceplantomanagethisrisk.Whatshouldyoudo？（）

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

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064