You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 to administrate and maintain its database.
You have received instruction from management to create a repository of function information.
This repository should be created with the following characteristics:
* The data collector is utilized to collect function information.
* One database reserves function information for all the instances.
* 15 Day old function information must be removed.
* Administrative effort to query and operate function data should be minimal.
What should you do?
A.
You should consider creating a single Microsoft SQL Server 2005 Analysis Services (SSAS)
package process to reserve and remove performance data.
B.
You should consider setting a management data warehouse process on every instance to
reserve and remove performance data in one database for all the instances.
C.
You should consider creating a single Microsoft SQL Service Integration Services (SSIS)
package process to reserve and remove performance data.
D.
You should consider creating a single Microsoft SQL Server 2005 Reporting Services (SSRS).