Microsoft

70-459 · Question #28

You execute the following code. You need to reduce the amount of time it takes to execute the query. What should you do?

The correct answer is A. Change SUBSTRING(JobTitle,1, 1) = `c' to JobTitle LIKE `c%1'. See the full explanation below for the reasoning.

Question

You execute the following code. You need to reduce the amount of time it takes to execute the query. What should you do?

Exhibit

70-459 question #28 exhibit

Options

AChange SUBSTRING(JobTitle,1, 1) = c' to JobTitle LIKE c%1'.
BPartition the table and use the JobTitle column for the partition scheme.
CReplace IX_Employees with a clustered index.
DChange SUBSTRING (JobTitle, 1, 1) = V to LEFT(JobTitle ,1) = 'c'.

How the community answered

(34 responses)

A
74% (25)
B
3% (1)
C
9% (3)
D
15% (5)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 70-459 Practice