Override the SQL of a non-shared, uncached Lookup transformation

It is desired to override the SQL of a non-shared, uncached Lookup transformation in order to add a WHERE clause. Select the action below that MUST be taken to allow the session to run as designed. Assume that the session has already been tested prior to the override and it is satisfactory.

Choose Answer

(A)
Cache the Lookup
(B)
Include an ORDER BY clause in the SQL that sorts the lookup field(s) in descending order.
(C)
Generate a default query after the override SQL has been entered.
(D)
Validate the override SQL on the actual database table.