Microsoft
70-458 · Question #117
You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2012 Standard Edition. The server hosts a database named Orders. Users report that a query that filters on OrderDate…
The correct answer is C. Option C. See the full explanation below for the reasoning.
Question
You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2012 Standard Edition. The server hosts a database named Orders. Users report that a query that filters on OrderDate is taking an exceptionally long time. You discover that an index named IX_OrderDate on the CustomerOrder table is heavily fragmented. You need to improve the performance of the IX_OrderDate index. The index should remain online during the operation. Which Transact-SQL command should you use?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(45 responses)- A9% (4)
- B4% (2)
- C84% (38)
- D2% (1)
Community Discussion
No community discussion yet for this question.