A Development Team at an International Gaming Company Is Experimenting

question 110

Multiple Choice

A development team at an international gaming company is experimenting with Amazon DynamoDB to store in-game events for three mobile games. The most popular game hosts a maximum of 500,000 concurrent users, and the least popular game hosts a maximum of 10,000 concurrent users. The average size of an event is 20 KB, and the average user session produces one event each second. Each event is tagged with a time in milliseconds and a globally unique identifier. The lead developer created a single DynamoDB table for the events with the following schema: Partition key: game name Sort key: event identifier Local secondary index: player identifier Event time The tests were successful in a small-scale development environment. However, when deployed to production, new events stopped being added to the table and the logs show DynamoDB failures with the ItemCollectionSizeLimitExceededException error code. Which design change should a database specialist recommend to the development team?

• A) Use the player identifier as the partition key. Use the event time as the sort key. Add a global secondary index with the game name as the partition key and the event time as the sort key.
• B) Create two tables. Use the game name as the partition key in both tables. Use the event time as the sort key for the first table. Use the player identifier as the sort key for the second table.
• C) Replace the sort key with a compound value consisting of the player identifier collated with the event time, separated by a dash. Add a local secondary index with the player identifier as the sort key.
• D) Create one table for each game. Use the player identifier as the partition key. Use the event time as the sort key.

---

Definitions:

Wholly Owned

A company whose entire share capital is 100% owned by another company, making it a complete subsidiary.

Unrealized Profit

Profits that have been accounted for but not yet realized through a transaction, such as stocks that have increased in value but have not been sold.

Consolidated Financial Statements

Financial statements that present the assets, liabilities, and operating results of a parent company and its subsidiaries as one entity.

Beginning Inventory

The value of all inventory held by a company at the start of an accounting period.