You are building a "game high score" table in DynamoDB for many games, and the highest score for each game will be stored in the table. The table includes some columns such as "Name of the game", "Name of the user", "UserID", etc. The web application needs to get the highest score of certain games from the table frequently. You also need a suitable partition key to distribute the workload evenly. How would you design the structure of the DynamoDB table?

Answer options:

A.HighestScore as the partition key.
B.UserID as the partition key and HighestScore as the sort key.
C.UserID as the partition key.
D.UserID as the sort key.

Answer – B
It is better to choose the partition key that has a wide range of values. This is also given in the AWS documentation.
Besides, as you need to retrieve the Highest Score, you can configure it as the sort key.
For more information on the DynamoDB guidelines, please visit the below URL:
http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/GuidelinesForTables.html