AWS Certified Developer - Associate
Get started today
Ultimate access to all questions.
Your application has been successfully using a DynamoDB table for over a year without throttling issues, thanks to appropriately provisioned Read Capacity Units (RCUs) and Write Capacity Units (WCUs). Recently, you have introduced a secondary query type that necessitated the creation of a Local Secondary Index (LSI) and a Global Secondary Index (GSI) on a new table to meet this need. However, a month after implementing these indexes, the table is now experiencing throttling.
Upon examining the table's metrics, you can see that the provisioned RCU and WCU levels are still adequate. What could be causing the throttling?
Your application has been successfully using a DynamoDB table for over a year without throttling issues, thanks to appropriately provisioned Read Capacity Units (RCUs) and Write Capacity Units (WCUs). Recently, you have introduced a secondary query type that necessitated the creation of a Local Secondary Index (LSI) and a Global Secondary Index (GSI) on a new table to meet this need. However, a month after implementing these indexes, the table is now experiencing throttling.
Upon examining the table's metrics, you can see that the provisioned RCU and WCU levels are still adequate. What could be causing the throttling?
Explanation:
The GSI is throttling so you need to provision more RCU and WCU to the GSI
DynamoDB supports two types of secondary indexes:
Global secondary index — An index with a partition key and a sort key that can be different from those on the base table. A global secondary index is considered "global" because queries on the index can span all of the data in the base table, across all partitions. A global secondary index is stored in its own partition space away from the base table and scales separately from the base table.
Local secondary index — An index that has the same partition key as the base table, but a different sort key. A local secondary index is "local" in the sense that every partition of a local secondary index is scoped to a base table partition that has the same partition key value.