DVA-C02 · Question #86
A developer is working on an existing application that uses Amazon DynamoDB as its data store. The DynamoDB table has the following attributes: partNumber (partition key), vendor (sort key), descripti
The correct answer is A. Create a global secondary index (GSI) with productFamily as the partition key and productType. Create a Global Secondary Index (GSI): The developer should create a new GSI on the DynamoDB table with the productFamily attribute as the partition key and the productType attribute as the sort key. This will allow the application to perform fast queries on these attributes with
Question
A developer is working on an existing application that uses Amazon DynamoDB as its data store. The DynamoDB table has the following attributes: partNumber (partition key), vendor (sort key), description, productFamily, and productType. When the developer analyzes the usage patterns, the developer notices that there are application modules that frequently look for a list of products based on the productFamily and productType attributes. The developer wants to make changes to the application to improve performance of the query operations. Which solution will meet these requirements?
Options
- ACreate a global secondary index (GSI) with productFamily as the partition key and productType
- BCreate a local secondary index (LSI) with productFamily as the partition key and productType as
- CRecreate the table. Add partNumber as the partition key and vendor as the sort key. During table
- DUpdate the queries to use Scan operations with productFamily as the partition key and
How the community answered
(63 responses)- A75% (47)
- B3% (2)
- C6% (4)
- D16% (10)
Explanation
Create a Global Secondary Index (GSI): The developer should create a new GSI on the DynamoDB table with the productFamily attribute as the partition key and the productType attribute as the sort key. This will allow the application to perform fast queries on these attributes without scanning the entire table.
Community Discussion
No community discussion yet for this question.