Microsoft
70-458 · Question #130
You administer a Microsoft SQL Server 2012 database that contains a table named AccountTransaction. You discover that query performance on the table is poor due to fragmentation on the…
The correct answer is B. ALTER INDEX ALL ON AccountTransaction REBUILD. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2012 database that contains a table named AccountTransaction. You discover that query performance on the table is poor due to fragmentation on the IDX_AccountTransaction_AccountCode non-clustered index. You need to defragment the index. You also need to ensure that user queries are able to use the index during the defragmenting process, Which Transact-SQL batch should you use?
Options
- AALTER INDEX IDX_AccountTransaction_AccountCode
- BALTER INDEX ALL ON AccountTransaction REBUILD
- CALTER INDEX IDX_AccountTransaction_AccountCode
- DCREATE INDEX IDX AccountTransactionAccountCode
How the community answered
(23 responses)- A4% (1)
- B78% (18)
- C13% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.