DB2 10 for z/OS Database Administrator — Question 47

When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density. What can cause an MDC table to use much more space?

Answer options

• A. The page size is too small.
• B. The extent size is too small.
• C. Low cardinality of the dimension(s) chosen.
• D. High cardinality of the dimension(s) chosen.

Correct answer: D

Explanation

The correct answer is D, as high cardinality in the dimensions can lead to numerous distinct values, causing an increase in storage space requirements. Options A and B refer to sizes that do not directly relate to cardinality issues, while C addresses low cardinality, which typically results in better space efficiency.