You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization,optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 infrastructure is managed by you. 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)
A.
System monitor counters should be reviewed regularly.
B.
After deployment of the production databases, the system should be basedlined.
C.
All databases should be backed up every day.
D.
The system log and the application log should be cleared every hour.
E.
A maintenance plan that rebuilds indexes every week should be created.