nerdexam
Microsoft

70-450 · Question #6

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

Sign in or unlock 70-450 to reveal the answer and full explanation for question #6. The question stem and answer options stay visible for context.

Question

You administer a SQL Server 2008 instance. The instance is using a 32-bit version on a Windows Server 2008 64-bit server. The awe enabled option is enabled. The instance will experience a predictable increase in query activity. You plan to ascertain the appropriate time when the migration of the databases to a 64-bit SQL Server 2008 server on the same hardware is beneficial. You need to identify a data collector type that provides the appropriate information. Which collector should you use?

Options

  • ASQL Trace collector
  • BT-SQL Query collector
  • CQuery Activity collector
  • DPerformance Counters collector

Unlock 70-450 to see the answer

You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 70-450 Practice