Question 45:
A sales application stores inventory of available items for purchase.Each item is uniquely identified by its Part Number, and contains additional attributes: Part Type, Manufacture Date, Manufacturer Name, Country of Origin, and Cost. The application requires to retrieve item information during each sales transaction. Further, it produces reports for a list of sales for each country. What would be the optimal DynamoDB data model for this application?
Answer options:
A.Table Partition Key=Manufacture Date; Table Sort Key=Part Number; GSI Partition Key= Manufacturer Name; GSI Sort Key=Country of Origin; B.Table Partition Key=Part Number; Table Sort Key=Part Type; GSI Partition Key=Country of Origin; GSI Sort Key=Manufacturer Name; C.Table Partition Key=Part Number; Table Sort Key=Part Type; GSI Partition Key=Random Prefix; GSI Sort Key=Country of Origin; D.Table Partition Key=Part Number; Table Sort Key=Part Type; GSI Partition Key= Manufacture Date; GSI Sort Key=Country of Origin;