Microsoft
MB7-700 · Question #92
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 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
How the community answered
(48 responses)- A4% (2)
- B15% (7)
- C8% (4)
- D73% (35)
Community Discussion
No community discussion yet for this question.