ST0-118 · Question #204
In an environment with Symantec Enterprise Vault 10 .0 for Exchange using SQL 2005, an administrator has checked the health of a database and received the results below: x TABLE level scan…
The correct answer is C. the high Extent Scan Fragmentation D. the difference between Extents Scanned and Extent Switches. See the full explanation below for the reasoning.
Question
In an environment with Symantec Enterprise Vault 10 .0 for Exchange using SQL 2005, an administrator has checked the health of a database and received the results below: *x TABLE level scan performed. *x - Pages Scanned: 13276 *x - Extents Scanned: 1590 *x - Extent Switches: 1605 *x - Avg. Pages per Extent: 81 *x - Scan Density [Best Count: Actual Count].:
989900% [1570:1610] *x - Logical Scan Fragmentation: 759% *x - Extent Scan Fragmentation:
8538% *x - Avg. Bytes Free per Page: 1062 *x - Avg. Page Density (full): 9795% Which two issues should the administrator be concerned about and resolve? (Select two.)
Options
- Athe high Avg. Page Density (full)
- Bthe high Scan Density [Best Count: Actual Count]
- Cthe high Extent Scan Fragmentation
- Dthe difference between Extents Scanned and Extent Switches
- Ethe amount of Pages Scanned
How the community answered
(25 responses)- A4% (1)
- B4% (1)
- C80% (20)
- E12% (3)
Community Discussion
No community discussion yet for this question.