nerdexam
Microsoft

70-450 · Question #4

You administer a SQL Server 2008 infrastructure. Your company requires capacity planning information. You need to design a long-term infrastructure monitoring strategy. Which two tasks should you incl

Sign in or unlock 70-450 to reveal the answer and full explanation for question #4. The question stem and answer options stay visible for context.

Maintain a BI Solution

Question

You administer a SQL Server 2008 infrastructure. Your company requires capacity planning information. You need to design a long-term infrastructure monitoring strategy. Which two tasks should you include in your design? (Each correct answer presents part of the solution. Choose two.)

Options

  • ABackup all databases every day.
  • BClear the system log and the application log every hour.
  • CReview system monitor counters on a regular basis.
  • DBaseline the system before you deploy production databases.
  • ECreate a maintenance plan that rebuilds indexes every week.

Unlock 70-450 to see the answer

You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#capacity planning#infrastructure monitoring#system monitor counters#performance baseline
Full 70-450 Practice