70-450 · Question #34
You are a professional level SQL Sever 2008 Database Administrator. The capacity planning information is required by your company. A long-term infrastructure monitoring strategy should be…
The correct answer is A. System monitor counters should be reviewed regularly. B. After deployment of the production databases, the system should be basedlined. After the production deployment, we will set a baseline of system counter in order to have metrics about the health of the server. This is useful in order to query on a regular basis the status of those counter. When big deviation from the counters are seen, further…
Question
You are a professional level SQL Sever 2008 Database Administrator. The capacity planning information is required by your company. A long-term infrastructure monitoring strategy should be implemented. Which two actions should be contained in the strategy? (Choose more than one)
Options
- ASystem monitor counters should be reviewed regularly.
- BAfter deployment of the production databases, the system should be basedlined.
- CAll databases should be backed up every day.
- DThe system log and the application log should be cleared every hour.
- EA maintenance plan that rebuilds indexes every week should be created.
How the community answered
(29 responses)- A76% (22)
- C14% (4)
- D7% (2)
- E3% (1)
Explanation
After the production deployment, we will set a baseline of system counter in order to have metrics about the health of the server. This is useful in order to query on a regular basis the status of those counter. When big deviation from the counters are seen, further investigation could be done to solve potential problem.
Topics
Community Discussion
No community discussion yet for this question.