HP
HP2-N36 · Question #14
Which methods are available to optimize a projection for delete processing? (Select two.)
The correct answer is A. Add a low cardinality column to the beginning of all projections on the source table. C. Add all columns used as delete predicates to all projections on the source table. See the full explanation below for the reasoning.
Question
Which methods are available to optimize a projection for delete processing? (Select two.)
Options
- AAdd a low cardinality column to the beginning of all projections on the source table.
- BAdd a high cardinality column to the end of all projections on the source table.
- CAdd all columns used as delete predicates to all projections on the source table.
- DAdd a low cardinality column to the end of all projections on the source table.
- EAdd a high cardinality column to the beginning of all projections on the source table.
How the community answered
(42 responses)- A74% (31)
- B14% (6)
- D5% (2)
- E7% (3)
Community Discussion
No community discussion yet for this question.