PrepAway - Latest Free Exam Questions & Answers

Which two statements accomplish this requirement?

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.)

PrepAway - Latest Free Exam Questions & Answers

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:


Leave a Reply