A job is designed with 3 Join stages in sequence. Join_1 keys are “Account”, “Customer” and “PO_Date”
Join_2 keys are “Account”, “Customer” and “Txn” Join_3 keys are “Account”, “Product_CD” and “Txn”
Which of the following will lead to the best run time performance?

A.
Left links are Hash partitioned on “Account” for all joins Right links are Hash partitioned on “Account” for
all joins

B.
Both left and right links are Hash partitioned as follows: Join_1 by “Account”, “Customer” and “PO_Date”
Join_2 by “Account”, “Customer” and “Txn” Join_3 by “Account”, “Product_CD” and “Txn”

C.
Both left and right links are Hash partitioned as follows: Join_1 by “Account” and “Customer”
Join_2 by “Account” and “Customer” Join_3 by “Account”

D.
Left links are Hash partitioned on “Account” for the first two joins and on “Product_CD” for the third.
Right links are Hash partitioned on “Account” for all joins