Designing tables with Local Secondary Indexes
You have an "Orders" table with userId (partition key) and orderDate (sort key). You need to query orders by userId and sort them by orderStatus (pending, shipped, delivered) instead of orderDate. You're considering adding a Local Secondary Index (LSI) on orderStatus.
Which statement is TRUE about using an LSI for this requirement?
This exercise is part of the course
Using Data Stores in AWS
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise