A Company's Ecommerce Website Uses Amazon DynamoDB for Purchase Orders

Multiple Choice

A company's ecommerce website uses Amazon DynamoDB for purchase orders. Each order is made up of a Customer ID and an Order ID. The DynamoDB table uses the Customer ID as the partition key and the Order ID as the sort key. To meet a new requirement, the company also wants the ability to query the table by using a third attribute named Invoice ID. Queries using the Invoice ID must be strongly consistent. A database specialist must provide this capability with optimal performance and minimal overhead. What should the database administrator do to meet these requirements?

A) Add a global secondary index on Invoice ID to the existing table.
B) Add a local secondary index on Invoice ID to the existing table.
C) Recreate the table by using the latest snapshot while adding a local secondary index on Invoice ID.
D) Use the partition key and a FilterExpression parameter with a filter on Invoice ID for all queries.