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

question 78

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.

---

Definitions:

Costocervical Artery

An artery that supplies blood to the upper dorsal region of the body, including parts of the neck and shoulders.

Gastrosplenic Artery

A blood vessel that supplies blood to the stomach and spleen, often referred to as the splenic artery when specifically regarding its supply to the spleen.

Cranial Mesenteric Artery

A significant artery that supplies blood to a large portion of the small and large intestines.

Abdominal Aorta

The largest artery in the abdominal cavity that supplies blood to the lower part of the body.