IBM
C2090-303 · Question #97
Each row contains the CustID, ProductID, ProductType and TotalAmount columns. You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a…
The correct answer is A. Hash-partition on CustID. Sort on CustID, ProductType and TotalAmount. See the full explanation below for the reasoning.
Question
Each row contains the CustID, ProductID, ProductType and TotalAmount columns. You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a RemoveDuplicates stage. How can this be accomplished?
Options
- AHash-partition on CustID. Sort on CustID, ProductType and TotalAmount.
- BHash-partition on TotalAmount. Sort on CustID, ProductType and TotalAmount.
- CHash-partition on ProductType. Sort on ProductType, CustID and TotalAmount.
- DHash-partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and
How the community answered
(17 responses)- A82% (14)
- B12% (2)
- D6% (1)
Community Discussion
No community discussion yet for this question.