McAfee

MA0-100 · Question #160

What option should be selected in the SQL maintenance plan rebuild index?

The correct answer is B. Change free space per page percentage to. See the full explanation below for the reasoning.

Question

What option should be selected in the SQL maintenance plan rebuild index?

Options

AReorganize the pages with the default amount of free space
BChange free space per page percentage to
CSort results in tempdb
DKeep index online while reindexing

How the community answered

(41 responses)

A
2% (1)
B
73% (30)
C
7% (3)
D
17% (7)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full MA0-100 Practice