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

What is the primary purpose of choosing a partition key and sort key when creating a new table?

• To enable querying based on specific attributes

• To set the table's security settings

• To determine the table's physical location

• To define the storage capacity of the table

Which of the following is true about Local Secondary Indexes (LSIs)?

• They require separate read and write capacity settings

• They must be defined at table creation

• They allow for a different partition key

• They can be created at any time after the table is created

When configuring a local secondary index, what can be specified differently from the main table?

• Partition key

• Sort key

• Table name

• Provisioned capacity

What is a key difference between Global Secondary Indexes (GSIs) and Local Secondary Indexes (LSIs)?

• LSIs can be created after the table is created

• GSIs must be defined at table creation

• LSIs require separate read and write capacity settings

• GSIs can have a different partition key from the main table

What happens if a GSI experiences high query traffic?

• The main table's read and write operations are unaffected

• The main table's write operations may be throttled

• The GSI automatically scales to handle the load

• The GSI is disabled until traffic decreases