PrepAway - Latest Free Exam Questions & Answers

which gathers and uploads information in the management informationwarehouse on different schedules. What shou

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply