Exam 70-462 topic 2 question 43 discussion

Actual exam question from Microsoft's 70-462

Question #: 43
Topic #: 2

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?

A. ALTER INDEX IDX_AccountTransaction_AccountCode ON AccountTransaction.AccountCode REORGANIZE
B. ALTER INDEX ALL ON AccountTransaction REBUILD
C. ALTER INDEX IDX_AccountTransaction_AccountCode ON AccountTransaction.AccountCode REBUILD
D. CREATE INDEX IDXAccountTransactionAccountCode ON AccountTransaction.AccountCode WITH DROP EXISTING

Show Suggested Answer

Suggested Answer: A 🗳️

by moowoo at Feb. 19, 2020, 8:37 p.m.

Comments

Submit Cancel

corpo

4 years, 10 months ago

Answer is A. ALTER INDEX IDX_AccountTransaction_AccountCode ON AccountTransaction.AccountCode REORGANIZE

upvoted 1 times

...

moowoo

5 years, 3 months ago

Answer is A

upvoted 1 times

...