A Company Is Building an Application to Track Athlete Performance

question 312

Multiple Choice

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?

• A) Use a DynamoDB query operation with the key attributes of user_id and sport_name and order the results based on the score attribute. Use a DynamoDB query operation with the key attributes of user_id and sport_name and order the results based on the score attribute.
• B) Create a global secondary index with a partition key of sport_name and a sort key of score, and get the results Create a global secondary index with a partition key of and a sort key of score, and get the results
• C) Use a DynamoDB scan operation to retrieve scores and user_id based on sport_name , and order the results based on the score attribute. Use a DynamoDB scan operation to retrieve scores and based on , and order the results based on the score attribute.
• D) 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. Create a local secondary index with a primary key of and a sort key of score and get the results based on the

---

Definitions:

Baking Soda

A common household sodium bicarbonate powder used for baking, cleaning, and odor neutralizing.

Sectional Diameter

The diameter of a circular object or a section thereof, often used in the context of mechanical parts or engineering to describe specific measurements.

SAE Metric

Refers generally to tools or system measurements that are based on the metric system and standardized by the Society of Automotive Engineers.

Data Bus

A system for exchanging data within a computer or between multiple computers.