Microsoft Exam 98-364 Topic 2 Question 39 Discussion

Actual exam question for Microsoft's exam

Question #: 39
Topic #: 2

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?

ANon-null constraint

BDefault constraint

CIndex

DForeign key

Show Suggested Answer

Suggested Answer: D

by Tammara at May 03, 2022, 09:01 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!