Examkin

Question

Difficulty: MediumAWS Database Services

A financial services firm is building a new application and needs to select the appropriate database services for two specific components. First, they need a database to handle high-frequency transactional data that requires complex SQL joins and strict ACID compliance. Second, they need a fast data store to keep user session states with sub-millisecond latency. Which two AWS database services should the firm choose to meet these requirements?

  1. Amazon AuroraAnswer
  2. Amazon ElastiCacheAnswer
  3. C
    Amazon DynamoDB
  4. D
    Amazon Redshift
  5. E
    Amazon Neptune

Answer

The correct services are Amazon Aurora and Amazon ElastiCache.
Amazon Aurora provides PostgreSQL and MySQL-compatible relational engines capable of running complex joins and enforcing ACID transactions, satisfying the transactional workload requirement. Amazon ElastiCache provides Redis and Memcached in-memory caching configurations that satisfy the sub-millisecond retrieval constraint for session state storage.

Step-by-Step Solution

1
Analyze the requirements for the first component: transactional data, complex SQL joins, and strict ACID compliance.
Determine that Amazon Aurora matches this relational database profile (OLTP).
Relational databases are structured to handle relational models and ensure transactional consistency.
2
Analyze the requirements for the second component: user session states needing sub-millisecond latency.
Determine that Amazon ElastiCache matches this caching/in-memory data store profile.
In-memory caches are specifically built to bypass disk reads and achieve sub-millisecond query responses.

Key Concept

Choosing AWS databases according to specific workloads (relational transactions vs. in-memory caching)
Rate this question

Topics

AWS Database Services

More questions from this topic