nerdexam
Microsoft

70-450 · Question #9

70-450 Question #9: Real Exam Question with Answer & Explanation

The correct answer is C. Performance Counters collector. Background info:

Question

You administer a SQL Server 2008 infrastructure. A financial application uses several instances across multiple servers. The majority of queries require distributed transactions across all servers. The application administrator reports that the application experiences excessive deadlocks. You need to design a data collector type that provides the appropriate information for remote servers. What collector should you use?

Options

  • AT-SQL Query collector
  • BQuery Activity collector
  • CPerformance Counters collector
  • DA custom Query collector that uses WMI

Explanation

Background info:

Community Discussion

No community discussion yet for this question.

Full 70-450 Practice