Microsoft
70-458 · Question #130
70-458 Question #130: Real Exam Question with Answer & Explanation
Sign in or unlock 70-458 to reveal the answer and full explanation for question #130. The question stem and answer options stay visible for context.
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
Unlock 70-458 to see the answer
You've previewed enough free 70-458 questions. Unlock 70-458 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.