Examkin

Question

Difficulty: MediumAWS Database Services

A media streaming company is designing a new application. The architecture requires a fully managed database to store and retrieve user session state data with single-digit millisecond latency at any scale. Additionally, the company needs a data warehouse solution to run complex analytical queries over petabytes of historical user viewing history for business intelligence reports. Which TWO AWS services should the company select to meet these requirements?

  1. Amazon DynamoDBAnswer
  2. Amazon RedshiftAnswer
  3. C
    Amazon RDS for MySQL
  4. D
    Amazon Neptune
  5. E
    Amazon S3

Answer

Amazon DynamoDB and Amazon Redshift
Amazon DynamoDB is a NoSQL key-value database designed to handle high-throughput workloads with single-digit millisecond latency, making it the correct choice for user session state data. Amazon Redshift is a fully managed data warehouse designed specifically to handle complex analytical queries over petabytes of structured data for business intelligence reporting.

Step-by-Step Solution

1
Analyze the first requirement: a database to store and retrieve user session state data with single-digit millisecond latency at any scale.
Identify that a fully managed NoSQL key-value database like Amazon DynamoDB is optimized for high-throughput, low-latency session store workloads.
Relational databases (like Amazon RDS) do not scale as easily or cost-effectively for millions of concurrent key-value lookups with sub-10ms response times.
2
Analyze the second requirement: a data warehouse solution to run complex analytical queries over petabytes of historical data.
Identify that Amazon Redshift is the dedicated AWS service for data warehousing and Online Analytical Processing (OLAP) at scale.
Standard databases are meant for transaction processing (OLTP) and perform poorly under heavy analytical queries across petabytes of historical data.

Key Concept

Selecting AWS database services based on specific workloads (NoSQL vs. data warehousing)
Rate this question

Topics

AWS Database Services

More questions from this topic