Question

Difficulty: MediumAWS Database Services

A financial technology company is refactoring its monolithic application into a microservices architecture. They have identified two distinct database requirements:

1. A transactional ledger that requires schema enforcement, complex relational joins, and strict ACID compliance.
2. A user session store that requires low-latency, single-digit millisecond response times for simple key-value lookups at high scale.

Which of the following database options should the cloud practitioner recommend to meet these requirements? (Select TWO.)

  1. Amazon Aurora to host the transactional ledger microservice.Answer
  2. Amazon DynamoDB to host the user session store microservice.Answer
  3. C
    Amazon Redshift to host the user session store because it provides columnar storage optimized for real-time key-value transactions.
  4. D
    Amazon RDS for the transactional ledger, with AWS assuming responsibility for database schema updates and query optimization.
  5. E
    A single Amazon Aurora instance hosting both microservices to maintain a tightly coupled database schema for simplified management.

Answer

Amazon Aurora to host the transactional ledger microservice, and Amazon DynamoDB to host the user session store microservice.
The correct choices are the option proposing Amazon Aurora for the transactional ledger and the option proposing Amazon DynamoDB for the user session store. Aurora provides high-performance relational features with ACID compliance, and DynamoDB is a managed NoSQL service that provides fast, single-digit millisecond latency for key-value user session data.

Step-by-Step Solution

1
Analyze the requirements for the first microservice.
The first microservice needs a relational database (SQL joins, schema enforcement, ACID transactions). Amazon Aurora is the correct choice here.
Relational databases are specifically designed to support structured data, schema constraints, and complex relational logic.
2
Analyze the requirements for the second microservice.
The second microservice needs a NoSQL key-value database providing low-latency scale. Amazon DynamoDB is the correct choice.
NoSQL databases like DynamoDB are optimized for horizontal scalability and high-throughput, low-latency access to key-value data.
3
Evaluate the architectural and administrative responsibilities.
AWS manages infrastructure tasks, but the customer retains responsibility for database schema modifications and query optimization. In addition, services should remain loosely coupled rather than sharing a single database engine.
This aligns with AWS Shared Responsibility and well-architected design principles.

Key Concept

Selecting appropriate AWS database services based on relational vs. NoSQL requirements, shared responsibility, and loose coupling design principles.
Rate this question