A developer is creating a web application for a school that stores data in Amazon DynamoDB. The ExamScores table has the following attributes: student_id, subject_name, and top_score.
Each item in the ExamScores table is identified with student_id as the partition key and subject_name as the sort key. The web application needs to display the student _id for the top scores for each school subject. The developer needs to increase the speed of the queries to retrieve the student_id for the top scorer for each school subject.
Which solution will meet these requirements?

A. Create a local secondary index (LSI) with subject_name as the partition key and top_score as the sort key.

B. Create a local secondary index (LSI) with top_score as the partition key and student_id as the sort key.

C. Create a global secondary index (GSI) with subject_name as the partition key and top_score as the sort key.

D. Create a global secondary index (GSI) with subject_name as the partition key and student_id as the sort key.








 

Suggested Answer: C

Community Answer: C




This question is in DVA-C02 AWS Certified Developer – Associate Exam
For getting AWS Certified Developer – Associate Certificate


Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Amazon.
Trademarks, certification & product names are used for reference only and belong to Amazon.
The website does not contain actual questions and answers from Amazon's Certification Exam.