You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. You have received instruction from management to keep a management data
warehouse. It will be used to store functions data through utilizing the data collector. For this, you
need to use a process which gathers and uploads information in the management information
warehouse on different schedules.
What should you do?
A.
You should consider developing different SQL Agent jobs.
B.
You should consider developing an on-demand non-cached data collection.
C.
You should consider developing a cached data collection.
D.
You should consider developing a scheduled non-cached data collection.