Exam AWS Certified Developer Associate topic 1 question 362 discussion

Ask: (1) Find the 10 reviews with the highest rating for a given product. - We need: Product ID as the partition key and Product Rating as the sort key. - Eliminate, LSI (2) FASTEST ==> GSI - A global secondary has its own provisioned throughput settings for read and write activity that are separate from those of the table. - A local secondary index shares provisioned throughput settings for read and write activity with the table it is indexing. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/bp-indexes-general.html

The correct answer is A. A global secondary index (GSI) with Product ID as the partition key and Product Rating as the sort key. A global secondary index (GSI) is a type of index in DynamoDB that has a different partition key than the table. In this case, the GSI should have Product ID as the partition key and Product Rating as the sort key. This will allow the GSI to be queried efficiently for the 10 reviews with the highest rating for a given product. Option B is incorrect because it does not include the Product Rating as the sort key, which is necessary for the query. Option C is incorrect because it uses a local secondary index (LSI), which can only be queried by the table's partition key and the LSI's sort key. Option D is incorrect because it uses the Review ID as the partition key, which is not relevant for the query.

Going with A

AAAAAA