Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise