nerdexam
Microsoft

70-459 · Question #43

You need to recommend a solution to minimize the amount of time it takes to execute sp1. With what should you recommend replacing Table1?

The correct answer is C. a view. See the full explanation below for the reasoning.

Question

You need to recommend a solution to minimize the amount of time it takes to execute sp1. With what should you recommend replacing Table1?

Options

  • Aa temporary table
  • Ba function
  • Ca view
  • Da table variable

How the community answered

(26 responses)
  • A
    12% (3)
  • B
    4% (1)
  • C
    81% (21)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice