nerdexam
Microsoft

70-451 · Question #13

You are troubleshooting query performance on SQL Server 2008. You are tasked to capture a graphical execution plan. You need to save the plan to a file that can be used by SQL Server Management…

The correct answer is D. .sqlplan. See the full explanation below for the reasoning.

Question

You are troubleshooting query performance on SQL Server 2008. You are tasked to capture a graphical execution plan. You need to save the plan to a file that can be used by SQL Server Management Studio to display the graphical execution plan. Which file extension should you use?

Options

  • A.gif
  • B.xml
  • C.psql
  • D.sqlplan

How the community answered

(45 responses)
  • A
    11% (5)
  • B
    4% (2)
  • C
    7% (3)
  • D
    78% (35)

Community Discussion

No community discussion yet for this question.

Full 70-451 Practice