nerdexam
Microsoft

70-457 · Question #170

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?

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

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:

Unlock 70-457 to see the answer

You've previewed enough free 70-457 questions. Unlock 70-457 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-457 Practice