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…
The correct answer is C. Review system monitor counters on a regular basis. D. Baseline the system before you deploy production databases. Establishing a performance baseline and keeping an eye on fluctuations is an ideal way to determine current and future resource requirements. Backing up databases and rebuilding indexes are good ideas, but not related to this task.
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.
How the community answered
(26 responses)- A4% (1)
- B12% (3)
- C77% (20)
- E8% (2)
Explanation
Establishing a performance baseline and keeping an eye on fluctuations is an ideal way to determine current and future resource requirements. Backing up databases and rebuilding indexes are good ideas, but not related to this task.
Topics
Community Discussion
No community discussion yet for this question.