You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2 to
administrate and maintain its database.
You have received instruction from management to create a strategy that makes use of the data
collector is utilized to collect performance information. Your strategy should also allow for 15 day
old information to be removed, and also reduce the amount of effort required to administer the
performance information.
Which of the following actions should you take?
A.
You should consider creating a single SQL Server 2008 R2 Analysis Services (SSAS) package
process to reserve and remove performance information.
B.
You should consider setting a management data warehouse process on every instance to
reserve and remove performance information in one database for all the instances.
C.
You should consider creating a single SQL Service Integration Services (SSIS) package
process to reserve and remove performance information.
D.
You should consider creating a single SQL Server 2008 R2 Reporting Services (SSRS).
Explanation: