Administering Microsoft SQL Server 2012/2014 Databases — Question 9

You administer a Microsoft Azure SQL Database 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 disabled.
You need to ensure that the query can use the IX_OrderDate index.
Which Transact-SQL command should you use?

Answer options

• A. ALTER INDEX IX_OrderDate ON CustomerOrder DISABLE
• B. ALTER INDEX IX_OrderDate ON CustomerOrder ENABLE
• C. ALTER INDEX IX_OrderDate ON CustomerOrder REORGANIZE
• D. ALTER INDEX IX_OrderDate ON CustomerOrder REBUILD

Correct answer: B

Explanation

The correct answer is B, as this command enables the IX_OrderDate index, allowing the query to utilize it effectively. Option A disables the index, which is counterproductive. Option C reorganizes the index but does not enable it, and option D rebuilds the index but does not directly address enabling a disabled index.