Examkin

Question

Difficulty: MediumAWS Database Services

An online ticketing platform needs a database that can handle sudden spikes in traffic during major ticket releases. The database must support complex transactional queries, be highly available across multiple Availability Zones, and automatically scale storage as the data grows. Which AWS service is designed to meet these relational database requirements?

  1. Amazon AuroraAnswer
  2. B
    DynamoDB
  3. C
    Redshift
  4. D
    ElastiCache

Answer

Amazon Aurora
Amazon Aurora is a cloud-native, relational database engine compatible with MySQL and PostgreSQL. It features a distributed, fault-tolerant storage system that automatically scales up to 128 TiB and replicates data across three Availability Zones. This makes it the correct choice for a high-performance, transactional ticketing application.

Step-by-Step Solution

1
Analyze the workload requirements
The application requires complex transactional queries, which indicates the need for a relational database.
Relational databases support ACID transactions and relational models needed for ticketing operations.
2
Evaluate operational requirements
The database must support automatic storage scaling and replication across multiple Availability Zones.
Handling traffic spikes and ensuring fault tolerance requires auto-scaling storage and high availability.
3
Compare matching AWS database services
Amazon Aurora matches all criteria, providing a fully managed, auto-scaling relational database compatible with MySQL and PostgreSQL.
Other options are either non-relational (DynamoDB), analytical (Redshift), or caching layers (ElastiCache).

Key Concept

Relational database services with high availability and automatic scaling
Rate this question

Topics

AWS Database Services

More questions from this topic