PrepAway - Latest Free Exam Questions & Answers

How can this be accomplished?

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?

PrepAway - Latest Free Exam Questions & Answers

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

B.
Hash-partition on TotalAmount. Sort on CustID, ProductType and TotalAmount.

C.
Hash-partition on ProductType. Sort on ProductType, CustID and TotalAmount.

D.
Hash-partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and
TotalAmount.

Explanation:


Leave a Reply