Within one municipal permit partition key, clerks need items sorted either by create-date or by fee-amount without copying the table. Which DynamoDB feature fits?
Select an answer to reveal the explanation.
Short Explanation
Same neighborhood (partition), different street sort—by date or by fee. An LSI keeps the same partition key and gives you another sort key so you don’t clone the whole table.
Full Explanation
A local secondary index (LSI) shares the base table’s partition key and provides an alternate sort key, which is ideal when alternate ordering is needed within the same partition. A GSI would redefine partition and sort keys and is better for cross-partition alternate access patterns. S3 Select and DAX do not create alternate sort keys on DynamoDB items.