Microsoft
70-459 · Question #113
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…
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'.
How the community answered
(45 responses)- A13% (6)
- B7% (3)
- C76% (34)
- D4% (2)
Community Discussion
No community discussion yet for this question.