Question

Difficulty: MediumAWS Database Services

A travel agency is launching a new booking platform. The platform has two requirements:
1. It must store and manage flight bookings and hotel reservations, which requires support for complex table joins and strong transaction integrity (ACID compliance).
2. It must store temporary flight search results and user session tokens to ensure sub-millisecond response times for frequent repeat searches.

Which of the following database services should the agency choose to meet these requirements? (Select TWO)

  1. Amazon AuroraAnswer
  2. Amazon ElastiCacheAnswer
  3. C
    Amazon DynamoDB
  4. D
    Amazon Redshift
  5. E
    A consolidated Amazon RDS DB instance storing both booking tables and temporary search results

Answer

Amazon Aurora and Amazon ElastiCache
Amazon Aurora provides the transactional compliance and relational capabilities required to manage complex hotel and flight reservations safely. Amazon ElastiCache offers the low-latency, in-memory caching performance necessary to handle session tokens and temporary search queries under sub-millisecond latency constraints.

Step-by-Step Solution

1
Evaluate the first requirement for flight bookings and hotel reservations.
This require transactional integrity (ACID compliance) and relational structures (table joins), which maps to relational database solutions such as Amazon Aurora.
Relational databases are designed to handle complex relationships between datasets with strong schema enforcement.
2
Evaluate the second requirement for temporary search results and session tokens.
This requires sub-millisecond response times for transient data, which maps to in-memory caching solutions such as Amazon ElastiCache.
In-memory caching reduces read latency to sub-millisecond levels by avoiding disk operations.

Key Concept

Selecting and combining relational and in-memory database services to support decoupled application requirements.
Estimated Time:1m 30s
Rate this question