IBM
C2090-303 · Question #142
In which two situations is it appropriate to use a Sparse Lookup? (Choose two.)
The correct answer is C. When reference data is significantly larger than the streaming data (100:1). D. When invoking a stored procedure within a database per row in the streaming link. See the full explanation below for the reasoning.
Question
In which two situations is it appropriate to use a Sparse Lookup? (Choose two.)
Options
- AWhen accessing DB2 data using the DB2 API stage.
- BWhen the output of the Lookup stage needs to be hashed partitioned.
- CWhen reference data is significantly larger than the streaming data (100:1).
- DWhen invoking a stored procedure within a database per row in the streaming link.
How the community answered
(26 responses)- A15% (4)
- B8% (2)
- C77% (20)
Community Discussion
No community discussion yet for this question.