Scenario: The Marketing Group is asking for a new feature to be added to the retail OLTP
application. They would like to have an online query that would list the last 30 days of purchases
for a given customer (credit card number). The file that currently contains this information is KeySequenced and it is updated every time a purchase is finalized. The primary key for this file is
system generated, the remaining data elements are: timestamp, credit card number, the part
number of the item being purchased, the price and the quantity purchased.
You have been asked to recommend the optimal way to access this data. Select ONE.

A.
Use the internal sort process and sort the file by the Timestamp

B.
Create an Alternate Key file, using the Timestamp as Alternate Key value and accessing the
file via the Alternate Key

C.
Use the internal sort process and sort the file by the Credit Card Number

D.
Create an Alternate Key file, using the Credit Card Number as Alternate Key value and
accessing the file via the Alternate Key