Question

A retail company stores order records in a DynamoDB table using OrderId as the partition key. Business analysts increasingly need to query orders by CustomerId and by OrderStatus, but these attributes are not part of the table's primary key. The queries must return results with low latency and must not require scanning the entire table. What is the MOST appropriate way to enable these access patterns?

Accepted Answer

Create global secondary indexes (GSIs) on CustomerId and OrderStatus so those attributes can be queried directly with low latency.

Answer

Enable DynamoDB adaptive capacity so the table can automatically handle the new query patterns without changes.

Answer

Run a Scan operation with filter expressions on CustomerId and OrderStatus each time analysts need results.

Answer

Create local secondary indexes (LSIs) on CustomerId and OrderStatus to add the alternate query keys.