IBM
000-349 · Question #42
000-349 Question #42: Real Exam Question with Answer & Explanation
Sign in or unlock 000-349 to reveal the answer and full explanation for question #42. The question stem and answer options stay visible for context.
Question
Given the following 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). Given a snapshot of a few records in the file: 1000ORRyan 1098OTPeter 1056PAJohn 1075PAJoanne 1020QDAlice 1099ZPAaron 1036ZXAali What is the most efficient function to use to find the first record where ShipToCustomer = "John".
Options
- ALOOKUP()
- BCHOOSE()
- CEXTRACT()
- DSEARCHUP()
- ESEARCHDOWN()
Unlock 000-349 to see the answer
You've previewed enough free 000-349 questions. Unlock 000-349 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.