nerdexam
Microsoft

70-457 · Question #170

70-457 Question #170: Real Exam Question with Answer & Explanation

The correct answer is C. Execute the following Transact-SQL statement:. See the full explanation below for the reasoning.

Question

You administer a Microsoft SQL Server 2012 instance. You need to stop a blocking process that has an SPID of 64 without stopping other processes. What should you do?

Options

  • AExecute the following Transact-SQL statement:
  • BRestart the SQL Server service.
  • CExecute the following Transact-SQL statement:
  • DExecute the following Transact-SQL statement:

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice