In an ecommerce application using Amazon DynamoDB to track product reviews, which index type and key configuration will provide the fastest query response for retrieving the top 10 highest-rated reviews for a specific product, given the table's partition key is Review ID?

Exam-Like

Global secondary index with Product ID as partition key and Product Rating as sort key

57.1%

Global secondary index with Product ID as partition key and Review ID as sort key

0.0%

Local secondary index with Product ID as partition key and Product Rating as sort key

28.6%

Local secondary index with Review ID as partition key and Product ID as sort key

14.3%

AWS Certified Developer - Associate