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…
Sign in or unlock MB7-700 to reveal the answer and full explanation for question #92. The question stem and answer options stay visible for context.
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
Unlock MB7-700 to see the answer
You've previewed enough free MB7-700 questions. Unlock MB7-700 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.