Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com makes use of multiple SQL Server
2008 R2 instances. One of the SQL Server 2008 R2 instances includes a database named
ABC_DB.
You have been instructed to devise a data collection solution that makes use of the data collector
to gather performance information of all the instances. Your solution should allow for the gathered
performance information to be reserved in ABC_DB. Your solution should also allow for function
data to be gathered and loaded in the management data warehouse every 12 hours.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com makes use of multiple SQL Server
2008 R2 instances. One of the SQL Server 2008 R2 instances includes a database named
ABC_DB.
You have been instructed to devise a data collection solution that makes use of the data collector
to gather performance information of all the instances. Your solution should allow for the gathered
performance information to be reserved in ABC_DB. Your solution should also allow for function
data to be gathered and loaded in the management data warehouse every 12 hours.
Which of the following actions should you take?

A.
You should consider configuring the Event log.

B.
You should consider configuring the Trace log.

C.
You should consider developing an on-demand cached data collection set.

D.
You should consider developing a scheduled non-cached data collection set.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *