Microsoft
MB7-700 · Question #92
MB7-700 Question #92: Real Exam Question with Answer & Explanation
The correct answer is D. DBCC INDEXDEFRAG. See the full explanation below for the reasoning.
Question
You are the IT engineer for a company. The personnel from the sales department complains about long waiting times when posting sales documents in RoleTailored client. You find out that indexes in the database are fragmented by 9%. In this case, which T-SQL statements do you use to defragment indexes on the SQL Server side?
Options
- ACREATE INDEX WITH DROP_EXISTING
- BALTER INDEX ON <object> REBUILD
- CDBCC DBREINDEX
- DDBCC INDEXDEFRAG
Community Discussion
No community discussion yet for this question.