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?
Martino88 is correct - the answer is an index. What would salary reference as a foreign key, as it is non-unique? Take these wrong answers with a grain of salt, but do learn from them.
This section is not available anymore. Please use the main Exam Page.98-364 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
martino88
Highly Voted 6 years, 3 months agobcstokes
Highly Voted 5 years, 6 months agoMeshalx
Most Recent 3 years, 1 month agoAkakiusz
3 years, 2 months agodzoni68
3 years, 2 months agoAshurs
3 years, 3 months agocurtis_dmb
3 years, 4 months agoBottlecap
3 years, 6 months agoJJ12345678
3 years, 9 months agoMarc_01
3 years, 11 months agobongo2020
4 years, 2 months agoKameljt
4 years, 6 months agoCertMeUp
4 years, 10 months agogoodidea
5 years ago