The purchase history record contains CustID, ProductID, ProductType and TotalAmount. You
need to retain the record of greatest TotalAmount per CustID and ProductType using
RemoveDuplicate stage. Which two statements accomplish this requirement? (Choose two.)
A.
Hash-partition on CustID;
Sort on CustID,ProductType and TotalAmount.
B.
Hash-partition on ProductType;
Sort on ProductType,CustID and TotalAmount.
C.
Hash-partition on CustID and ProductType;
Sort on CustID,ProductType and TotalAmount.
D.
Hash-partition on CustID,ProductType and TotalAmount;
Sort on CustID,ProductType and TotalAmount.
Explanation: