Exam 70-462 topic 2 question 193 discussion

Actual exam question from Microsoft's 70-462

Question #: 193
Topic #: 2

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?

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

Show Suggested Answer

Suggested Answer: B 🗳️
Enable a disabled index by using the Transact-SQL ALTER INDEX REBUILD command.
Incorrect Answers:
B: There is no ALTER INDEX ..ENABLE subcommand.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/enable-indexes-and-constraints https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-index-transact-sql

by Varad at Oct. 1, 2019, 7:53 p.m.