A company is building an application to track athlete performance using an Amazon DynamoDB table. Each item in the table is identified by a partition key (user_id) and a sort key (sport_name). The table design is shown below:
(Note: Not all table attributes are shown)
A Developer is asked to write a leaderboard application to display the top performers (user_id) based on the score for each sport_name. What process will allow the Developer to extract results MOST efficiently from the DynamoDB table?

Question

A company is building an application to track athlete performance using an Amazon DynamoDB table. Each item in the table is identified by a partition key (user_id) and a sort key (sport_name). The table design is shown below:

(Note: Not all table attributes are shown)

A Developer is asked to write a leaderboard application to display the top performers (user_id) based on the score for each sport_name. What process will allow the Developer to extract results MOST efficiently from the DynamoDB table?

Corey Rivers · Accepted Answer

Create a global secondary index with a partition key of sport_name and a sort key of score, and get the results

Corey Rivers · Answer

Use a DynamoDB query operation with the key attributes of user_id and sport_name and order the results based on the score attribute.

Corey Rivers · Answer

Use a DynamoDB scan operation to retrieve scores and user_id based on sport_name, and order the results based on the score attribute.

Corey Rivers · Answer

Create a local secondary index with a primary key of sport_name and a sort key of score and get the results based on the score attribute.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 162 - DVA-C01 discussion

Suggested answer: B

0 comments