Question

A developer is building an order-tracking service backed by a DynamoDB table named Orders. The table uses OrderId as the partition key. A new requirement asks the application to efficiently retrieve all orders belonging to a specific CustomerId, and CustomerId is not part of the table's primary key. The team wants to avoid full table scans and minimize query latency. What is the MOST appropriate way to support this access pattern?

Accepted Answer

Create a global secondary index (GSI) with CustomerId as the partition key and query the index.

Answer

Perform a Scan operation on the Orders table with a FilterExpression on CustomerId.

Answer

Create a local secondary index (LSI) with CustomerId as the sort key and query the index.

Answer

Enable DynamoDB Streams on the Orders table and replay events to find matching CustomerId values.