Question

A developer is designing a DynamoDB table for a customer support ticketing system. The table uses 'customerId' as the partition key and 'ticketId' as the sort key. Support agents frequently query all tickets for a customer sorted by 'lastUpdatedTimestamp', and these reads must always return the most recent write to guarantee agents never act on stale ticket status. Which approach satisfies this requirement?

Accepted Answer

Create a local secondary index (LSI) with 'customerId' as the partition key and 'lastUpdatedTimestamp' as the sort key, and use strongly consistent reads.

Answer

Create a global secondary index (GSI) with 'customerId' as the partition key and 'lastUpdatedTimestamp' as the sort key, and use strongly consistent reads.

Answer

Create a global secondary index (GSI) with 'lastUpdatedTimestamp' as the partition key and 'customerId' as the sort key, and use eventually consistent reads.

Answer

Add a DynamoDB Accelerator (DAX) cluster in front of the base table and query using the sort key 'ticketId'.