nerdexam
Microsoft

70-432 · Question #186

You administer a SQL Server 2008 instance. You need to identify the network protocol used by the current connection. What should you do?

The correct answer is B. Use a Dynamic Management View. See the full explanation below for the reasoning.

Question

You administer a SQL Server 2008 instance. You need to identify the network protocol used by the current connection. What should you do?

Options

  • AView the SQL error log.
  • BUse a Dynamic Management View.
  • CSet a trace flag.
  • DUse the T-SQL template in Profiler.

How the community answered

(22 responses)
  • A
    5% (1)
  • B
    82% (18)
  • C
    5% (1)
  • D
    9% (2)

Community Discussion

No community discussion yet for this question.

Full 70-432 Practice