A media company is building an online blogging platform on AWS. The platform requires a database tier to support two distinct use cases: first, it needs to store customer subscription details, billing history, and support complex SQL join queries for financial reports; second, it needs to store user session states, preferences, and unstructured comment metadata with single-digit millisecond latency. Which AWS database services should the company select to meet these requirements? (Select TWO.)
- Amazon AuroraAnswer
- Amazon DynamoDBAnswer
- CAmazon Redshift
- DAmazon ElastiCache
- EAmazon Neptune
Answer
Amazon Aurora and Amazon DynamoDB should be selected.
Amazon Aurora provides a high-performance relational database engine compatible with MySQL and PostgreSQL, making it the ideal choice for structured data requiring ACID compliance, complex SQL queries, and transactional integrity, such as subscription billing. Amazon DynamoDB is a fully managed NoSQL database service that provides single-digit millisecond latency at any scale, making it ideal for high-throughput, unstructured data such as user sessions, preferences, and comments.
Step-by-Step Solution
Key Concept
Distinguishing between relational (OLTP) and non-relational (NoSQL) database services in AWS based on application requirements.