nerdexam
Microsoft

70-433 · Question #35

You notice that a database server is responding slowly to queries. You run the following dynamic management views (DMV) query on the server. SELECT TOP (10) wait_type, wait_time_ms FROM…

The correct answer is B. CPU. See the full explanation below for the reasoning.

Question

You notice that a database server is responding slowly to queries. You run the following dynamic management views (DMV) query on the server. SELECT TOP (10) wait_type, wait_time_ms FROM sys.dm_os_wait_stats ORDER BY wait_time_ms DESC; The query returns a top wait type of SOS_SCHEDULER_YIELD. You need to identify what is causing the server response issues. Which resource should you investigate first?

Options

  • ADisk
  • BCPU
  • CMemory
  • DNetwork

How the community answered

(57 responses)
  • A
    4% (2)
  • B
    79% (45)
  • C
    11% (6)
  • D
    7% (4)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice