which of the following scenarios would you recommend using associative arrays?

In which of the following scenarios would you recommend using associative arrays?

A.
when you want to retrieve an entire row from a table and perform calculations

B.
when you know the number of elements in advance and the elements are usually accessed sequentially

C.
when you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries

D.
When you want to create a relatively small lookup table, where the collection can be constructed on memory each time a subprogram is invoked.