A gaming company is launching a new multiplayer game. They require a fully managed database solution to store real-time player profiles and session state data, which has a highly flexible schema and demands sub-millisecond, single-digit latency response times. Additionally, their data analyst team needs to store and analyze millions of rows of historical game logs from the past year to run complex, long-running business intelligence queries. Which TWO of the following solutions should the company implement to meet these requirements?
- Amazon DynamoDB to store player profiles and session state dataAnswer
- Amazon Redshift to run complex analytical queries on historical game logsAnswer
- CAmazon RDS for MySQL to store player profiles and session state data
- DAmazon Aurora configured as a single database to handle both operational session states and historical analytics
- EA self-managed PostgreSQL database hosted on Amazon EC2 to minimize administrative overhead for backups and OS patching
Answer
The company should implement Amazon DynamoDB to store player profiles and session state data, and Amazon Redshift to run complex analytical queries on historical game logs.
The correct services are Amazon DynamoDB and Amazon Redshift. Amazon DynamoDB provides the required single-digit millisecond latency and flexible key-value schema needed for live player profile and session state tracking. Amazon Redshift is designed specifically as a data warehouse to handle complex, long-running analytical queries on massive amounts of historical data without impacting the operational database.
Step-by-Step Solution
Key Concept
Selecting the correct AWS database service based on workload characteristics (NoSQL for low-latency operational data vs. data warehousing for complex analytics) and understanding the managed service responsibility model.