Exit 70-762 Developing SQL Databases
Question 4 of 5
0% complete
Q4 Single choice

You are experiencing performance issues with the database server.
You need to evaluate schema locking issues, plan cache memory pressure points, and backup I/O problems.

What should you create?

  • A

    a System Monitor report

  • B

    a sys.dm_exec_query_stats dynamic management view query

  • C

    a sys.dm_exec_session_wait_stats dynamicmanagement view query

  • D

    an Activity Monitor session in Microsoft SQL Management Studio.

Previous Next