PrepAway - Latest Free Exam Questions & Answers

How can this be accomplished?

You want to retain the record with the largest value in the TotalAmount column for each CustID and
ProductType using a Remove Duplicates stage. How can this be accomplished?

PrepAway - Latest Free Exam Questions & Answers

A.
Hash partition onTotalAmount. Sort on CustID, ProductType and TotalAmount

B.
Hash partition on ProductType. Sort on CustID, ProductType 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


Leave a Reply