In this scenario, there is one input file (SOHeader), which contains 200,000 records. The records
in SOHeader file are comprised of three fields: SONumber, SOOrdType, and ShipToCustomer.
The file is sorted by SOOrdType (ascending order).
Here is a snapshot of a few records in the file:

What is the MOST EFFICIENT function to use to find the first record where ShipToCustomer = “John”?

A.
LOOKUP()

B.
CHOOSE()

C.
EXTRACT()

D.
SEARCHUP()

E.
SEARCHDOWN()

Explanation: