Microsoft
MB7-700 · Question #94
You perform periodic maintenance of Microsoft SQL Server to evaluate the extent of index fragmentation in the critical tables in your Microsoft Dynamics NAV database. Which of the following metrics…
The correct answer is B. Scan Density is less than 75 percent. D. Logical Scan Fragmentation is above 10 percent. See the full explanation below for the reasoning.
Question
You perform periodic maintenance of Microsoft SQL Server to evaluate the extent of index fragmentation in the critical tables in your Microsoft Dynamics NAV database. Which of the following metrics indicate that the indexes in your database require defragmentation? Choose the 2 that apply.
Options
- AScan Density is more than 75 percent.
- BScan Density is less than 75 percent.
- CLogical Scan Fragmentation is below 10 percent.
- DLogical Scan Fragmentation is above 10 percent.
How the community answered
(37 responses)- A16% (6)
- B73% (27)
- C11% (4)
Community Discussion
No community discussion yet for this question.