Microsoft
98-364 · Question #254
You have the following SQL query SELECT * FROM dbo.ProAthlete WHERE Salary > 500000 The query takes too much time to return data. You need to improve the performance of the query. Which item should…
The correct answer is C. Index. See the full explanation below for the reasoning.
Question
You have the following SQL query SELECT * FROM dbo.ProAthlete WHERE Salary > 500000 The query takes too much time to return data. You need to improve the performance of the query. Which item should you add to the Salary column?
Options
- ANon-null constraint
- BDefault constraint
- CIndex
- DForeign key
How the community answered
(51 responses)- A4% (2)
- B10% (5)
- C73% (37)
- D14% (7)
Community Discussion
No community discussion yet for this question.