Microsoft
70-459 · Question #113
70-459 Question #113: Real Exam Question with Answer & Explanation
The correct answer is C. Replace LEFT(CustomerName ,1) = 'a' with CustomerName LIKE 'a%'.. See the full explanation below for the reasoning.
Question
You execute the following code: You create a nonclustered index named IXCustomerName on the CustomerName column. You execute the following query: You need to reduce the amount of time it takes to execute the query, What should you do?
Options
- APartition the table and use the CustomerName column for the partition scheme.
- BReplace IX_CustomerName with a clustered index.
- CReplace LEFT(CustomerName ,1) = 'a' with CustomerName LIKE 'a%'.
- DReplace LEFT(CustomerName ,1) = 'a' with SUBSTRING(CustomerName ,1,1) - 'a'.
Community Discussion
No community discussion yet for this question.