A customer wants to archive all orders from the Order table that are older than 24 months (2 years). The column name used to determine this is called “Created”.
How can an Optim developer implement this requirement?

A.
Create a storage profile that will automatically delete the archive after two years based upon the system date minus the created column if one record in the start table meets the criteria.

B.
Open the Orders access definition, position the cursor on the Order table and right click and use the archive actions tab from the “Table Specification” pop-up menu to enter a SQL statement
fragment “Createdbefore(24M)”.

C.
Open the Orders access definition, position the cursor on the Order table and right click and use the Selection Criteria tab on the “Table Specification” pop-up menu and find the “Created” column and enter the “before(24M)” for the selection criteria.

D.
Open the relationship editor for each child table related to orders and add “before(24M)” as an expression.