AWS DevOps Engineer Professional Practice Test

What is the maximum size of a Local Secondary Index in DynamoDB?

1. 5GB

2. 20GB

3. 10GB

4. 50GB

The correct answer is: 10GB

In Amazon DynamoDB, a Local Secondary Index (LSI) allows you to create an index on a table with the same partition key as the base table, but with a different sort key. This can significantly enhance query flexibility because you can query the table based on multiple sort keys. The maximum size of a Local Secondary Index is 10GB per partition key value. This is a critical limit to keep in mind when designing your database schema and consideration for scalability. If the data associated with a specific partition key exceeds this limit, you will encounter issues with using LSIs, as it would not be supported. The choice of 10GB reflects these constraints imposed by DynamoDB to maintain performance and usability standards. It encourages users to design their data model proactively, ensuring that the index use case remains efficient and sustainable within the limitations of the service.