What should you do?

You execute the following code.


After populating the Employees table with 10,000 rows, you execute the following query:


You need to reduce the amount of time it takes to execute the query.
What should you do?
A. Partition the table and use the JobTitle column for the partition scheme.
B. Change SUBSTRING(JobTitle,l,l) = ‘C to JobTitle LIKE ‘c%’
C. Change SUBSTRING (JobTitle, 1,1] = ‘c’ to LEFT(JobTitle ,1) = ‘c’.
D. Replace IX_Employees with a clustered index.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.