Domain 3.3: Performance Improvement — AWS SAP-C02 Practice Question 55

How to approach this question

Identify the DynamoDB feature used to query efficiently on non-primary key attributes.

Full Answer

A.Create a Global Secondary Index (GSI) on the table with 'EmailAddress' as the partition key. Update the application to query the GSI.✓ Correct

In DynamoDB, searching for an item by an attribute that is not the primary key requires a `Scan` operation, which reads every item in the table and consumes massive RCUs. To optimize this, you create a Global Secondary Index (GSI) with `EmailAddress` as the partition key. You can then perform a highly efficient `Query` operation on the GSI, drastically reducing RCU consumption and improving performance.

Common mistakes

Choosing LSI, which cannot be added after table creation and cannot change the partition key.

How to approach this question

Full Answer

Common mistakes

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 5

More questions from this exam