Notifications
Clear all
Topic starter
28/08/2022 10:55 pm
An online gaming company is planning to launch a new game with Amazon DynamoDB as its data store. The database should be designated to support the following use cases:
Update scores in real time whenever a player is playing the game. Retrieve a player’s score details for a specific game session.
A Database Specialist decides to implement a DynamoDB table. Each player has a unique user_id and each game has a unique game_id.
Which choice of keys is recommended for the DynamoDB table?
- A . Create a global secondary index with game_id as the partition key
- B . Create a global secondary index with user_id as the partition key
- C . Create a composite primary key with game_id as the partition key and user_id as the sort key
- D . Create a composite primary key with user_id as the partition key and game_id as the sort key
Suggested Answer: D
Explanation:
https://aws.amazon.com/blogs/database/amazon-dynamodb-gaming-use-cases-and-design-patterns/
"EA uses the user ID as the partition key and primary key (a 1:1 modeling pattern)." https://aws.amazon.com/blogs/database/choosing-the-right-dynamodb-partition-key/
"Partition key and sort key: Referred to as a composite primary key, this type of key is composed of two attributes. The first attribute is the partition key, and the second attribute is the sort key."
Explanation:
https://aws.amazon.com/blogs/database/amazon-dynamodb-gaming-use-cases-and-design-patterns/
"EA uses the user ID as the partition key and primary key (a 1:1 modeling pattern)." https://aws.amazon.com/blogs/database/choosing-the-right-dynamodb-partition-key/
"Partition key and sort key: Referred to as a composite primary key, this type of key is composed of two attributes. The first attribute is the partition key, and the second attribute is the sort key."