dynamoDB LSI

Question 1

What are the restrictions on creating a Local Secondary Index (LSI) in DynamoDB?

Answer 1

You can only create an LSI during the creation of a table.

Question 2

What is the key characteristic of an LSI in terms of its partition key?

Answer 2

An LSI always maintains the same partition key as the base table but has a different sort key.

Question 3

How is an LSI created in DynamoDB?

Answer 3

When creating an LSI, you only need to provide the sort key and any attributes you’d like to project.

Question 4

Is it possible to create an LSI on an existing table in DynamoDB?

Answer 4

No, creating an LSI on an existing table is not possible.

Question 5

What capacity units are used by LSIs?

Answer 5

LSIs use capacity units from the base table.

Question 6

What types of reads can you choose for LSIs?

Answer 6

You can choose strongly consistent or eventually consistent reads for LSIs.

Question 7

What happens if you query an attribute not projected from the base table in an LSI?

Answer 7

DynamoDB will fetch this attribute from the base table, which is costly and should be avoided.