A financial services firm is building a real-time portfolio management platform on AWS. The platform has two distinct database requirements: First, a persistent storage tier for user transaction history that requires complex multi-table SQL joins, strict ACID compliance, and the ability to scale read capacity automatically across multiple Availability Zones. Second, a caching layer to store frequently accessed market stock prices that requires sub-millisecond response times to handle massive spikes in read requests. Which combination of AWS database services best meets these requirements? (Select TWO.)
- Amazon AuroraAnswer
- Amazon ElastiCacheAnswer
- CAmazon DynamoDB
- DAmazon Redshift configured as a single database cluster to store both the transactional history and cache the stock prices
- EAmazon RDS, with the customer managing the underlying operating system security patches to ensure database reliability
Answer
The correct services are Amazon Aurora and Amazon ElastiCache.
The correct services are Amazon Aurora and Amazon ElastiCache. Amazon Aurora provides a fully managed relational database that scales storage automatically and supports up to 15 low-latency read replicas across multiple Availability Zones, which matches the transactional consistency and read scaling requirements. Amazon ElastiCache provides an in-memory cache with sub-millisecond latency, which is ideal for caching the highly dynamic stock prices.
Step-by-Step Solution
Key Concept
AWS Managed Database and Caching Services selection based on architectural requirements and the Shared Responsibility Model.
Estimated Time:2m 0s