Topic 1 Question 358
A developer is working on an app for a company that uses an Amazon DynamoDB table named Orders to store customer orders. The table uses OrderID as the partition key and there is no sort key. The table contains more than 100,000 records. The developer needs to add a functionality that will retrieve all Orders records that contain an OrderSource attribute with the MobileApp value.
Which solution will improve the user experience in the MOST efficient way?
Perform a Scan operation on the Orders table. Provide a QueryFilter condition to filter to only the items where the OrderSource attribute is equal to the MobileApp value.
Create a local secondary index (LSI) with OrderSource as the partition key. Perform a Query operation by using MobileApp as the key.
Create a global secondary index (GSI) with OrderSource as the sort key. Perform a Query operation by using MobileApp as the key.
Create a global secondary index (GSI) with OrderSource as the partition key. Perform a Query operation by using MobileApp as the key.
ユーザの投票
コメント(3)
- 正解だと思う選択肢: D
Answer : D
👍 5Alagong2024/07/01 Going for B, feel free to comment. I think these comments sections help me a lot!
👍 1Skip2024/07/01- 正解だと思う選択肢: C
You should add the OrderSource as the sort key, only the OrderID is unique should be set as the partition key to give the best performance
👍 1aws_god2024/11/05
シャッフルモード