IBM

C2090-312 · Question #26

A single table should allow for up to 100 Terabytes of application data. How do you design your table space?

The correct answer is D. A table space with MAXPARTITIONS 2048, DSSIZE 64G, BUFFERPOOL BP32K. See the full explanation below for the reasoning.

Question

A single table should allow for up to 100 Terabytes of application data. How do you design your table space?

Options

AA segmented compressed table space, BUFFERPOOL BP0.
BA LOB table space with DSSIZE 64GB, BUFFERPOOL BP8K0.
CA table space with NUMPARTS 1024, DSSIZE 64G, BUFFERPOOL BP16K0.
DA table space with MAXPARTITIONS 2048, DSSIZE 64G, BUFFERPOOL BP32K.

How the community answered

(33 responses)

A
3% (1)
B
6% (2)
C
12% (4)
D
79% (26)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full C2090-312 Practice