Refer to the exhibit.

Each order can have multiple products. The data architect needs to make sure the Amount can be analyzed by order Type and product Category.
The Order Number field data always contains the order Type in the first three characters. Product, Product Category, and Sales Channel data are available in an Excel spreadsheet called "Categories" in the file PaperProducts.xlsx.
Which two ways can the data architect use to make additions to the existing script and meet the requirements? (Choose two.)
A:

B:

C:

D: