IBM
A2090-560 · Question #121
What should be considered when you are asked to select the distribution key columns for a very large fact table?
The correct answer is D. Columns used to join to other large tables. See the full explanation below for the reasoning.
Question
What should be considered when you are asked to select the distribution key columns for a very large fact table?
Options
- AAs many columns as possible.
- BColumns that contain many nulls.
- CColumns that contain few unique values.
- DColumns used to join to other large tables.
How the community answered
(39 responses)- A13% (5)
- B5% (2)
- C3% (1)
- D79% (31)
Community Discussion
No community discussion yet for this question.