nerdexam
Symantec

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)
  • A
    4% (1)
  • B
    4% (1)
  • C
    80% (20)
  • E
    12% (3)

Community Discussion

No community discussion yet for this question.

Full ST0-118 Practice