单项选择题
A.Decrease the time between transaction log backups of the database.
B.Delete report snapshot history each week.
C.Minimize the use of session caching in the reports.
D.Minimize the use of report snapshots in the reports.
单项选择题 Youareadatabaseadministratorforyourcompany.Thecompany’sfinancialforecastingapplicationusesaSQLServer2005databasethatenablesbusinessuserstorunbothadhocandpredefinedqueries.Yoususpectthatsomequeriesconsumeanexcessiveamountofserverresources.Youneedtoidentifywhichqueriesconsumethemostresources.Youwanttoachievethisgoalasquicklyaspossible.Whatshouldyoudo？（）
单项选择题 YouaretheadministratorofaSQLServer2005computernamedSQL1.SQL1containsadatabasethatutilizesSQLServerlogshipping.Logshippingoccursevery30minutes.Eachnight，afullbackupismadeofthedatabase，andalldatabaseindexesarerebuilt.Thecompany’snetworkadministratorreportsthatSQL1snetworkutilizationbecomesexcessiveafterthenightlymaintenancetasksarecomplete.YouneedtoreducethenetworkbandwidthutilizationforSQL1.Whatshouldyoudo？（）
单项选择题 Youareadatabaseadministratorforyourcompany.Eachnight，youperformfullbackupsofyourSQLServer2005computer.Duringbusinesshours，youperformhourlytransactionlogbackups.Yourebuilddatabaseindexeseachnight.Youneedtomodifyyourbackupstrategy.Youmustensurethatthedatabaserecoverstoanewserverasquicklyaspossible.Whatshouldyoudo？（）