AWS Certified Data Analytics Specialty 2021 – Hands-On - DynamoDB Indexes (GSI + LSI)

The video tutorial explains two types of indexes in databases: Local Secondary Indexes (LSI) and Global Secondary Indexes (GSI). LSIs provide an alternative sort key while maintaining the same partition key, and must be defined at table creation. GSIs offer a different primary key and can be added or modified post table creation. The tutorial includes examples of using LSIs and GSIs for querying, and discusses throttling considerations, emphasizing careful planning of index and capacity settings.

What is a key characteristic of a Local Secondary Index (LSI) in DynamoDB?

• It allows for a different partition key.

• It can be added after table creation.

• It provides an alternative sort key.

• It requires separate read and write capacity units.

How many Local Secondary Indexes (LSIs) can you create per table in DynamoDB?

• Five

• Three

• Ten

• Unlimited

What is a unique feature of Global Secondary Indexes (GSIs) compared to Local Secondary Indexes (LSIs)?

• They can be modified after table creation.

• They must be defined at table creation.

• They do not allow for a different partition key.

• They use the main table's read and write capacity.

What must be provisioned for a Global Secondary Index (GSI) in DynamoDB?

• Only read capacity units

• Only write capacity units

• Both read and write capacity units

• No additional capacity units

What happens if a GSI in DynamoDB is throttled?

• The GSI will automatically scale.

• The main table is unaffected.

• Only the GSI is affected.

• The main table will also be throttled.