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)- A9% (3)
- B3% (1)
- C83% (29)
- D6% (2)
Community Discussion
No community discussion yet for this question.