nerdexam
Microsoft

70-451 · Question #134

You have a server that runs SQL Server 2008 Standard. The server provides data storage for a third- party contact management application. A service-level agreement for the application does not allow…

The correct answer is C. plan guides. See the full explanation below for the reasoning.

Question

You have a server that runs SQL Server 2008 Standard. The server provides data storage for a third- party contact management application. A service-level agreement for the application does not allow for modifications to be made to the application or to the database objects used by the application. You need to recommend a strategy to mitigate performance issues. The strategy must minimize database growth. What should you recommend?

Options

  • Aa scalable shared database
  • Bclustered indexes
  • Cplan guides
  • Dpartitioned tables

How the community answered

(35 responses)
  • A
    9% (3)
  • B
    3% (1)
  • C
    83% (29)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 70-451 Practice