Examkin

Question

Difficulty: HardAWS Database Services

A global logistics enterprise is migrating its central order-processing system to AWS. The workload requires a relational database that supports complex SQL joins and strict ACID transactions across multiple tables. The database storage must scale automatically up to 128 TiB128\text{ TiB} to handle peak seasonal data. Additionally, to satisfy disaster recovery requirements, the database must replicate data to a secondary AWS Region with a recovery point objective (RPO) of seconds and a recovery time objective (RTO) of less than one minute. Which AWS service should the enterprise select to meet these requirements?

  1. Amazon AuroraAnswer
  2. B
    Amazon DynamoDB
  3. C
    Amazon RDS for MySQL
  4. D
    Amazon Redshift

Answer

Amazon Aurora
Amazon Aurora meets all the criteria: it is a relational database (ACID compliant, supports SQL joins), its storage engine automatically scales up to 128 TiB128\text{ TiB}, and when configured as an Aurora Global Database, it provides cross-region replication with an RPO of seconds and an RTO of under a minute.

Step-by-Step Solution

1
Analyze the query workload requirements
The application requires a relational database supporting SQL joins and ACID transactions, which eliminates NoSQL options like Amazon DynamoDB.
Relational databases are required for structured schemas with complex multi-table relationships and transactional consistency.
2
Evaluate the database storage scale limits
The requirement for storage to scale up to 128 TiB128\text{ TiB} rules out standard Amazon RDS engines, which generally support up to 64 TiB64\text{ TiB}.
Amazon Aurora has a cloud-native storage engine that automatically scales storage up to 128 TiB128\text{ TiB} per database instance.
3
Evaluate disaster recovery RTO and RPO limits
The sub-minute RTO and near-instant RPO for cross-region replication require Amazon Aurora Global Databases.
Aurora Global Databases use storage-based replication to replicate data to secondary regions with typical latency of under a second and allow promoting a secondary region in less than a minute.

Key Concept

Identifying the use cases and limits of AWS relational database engines (RDS vs. Aurora) and comparing them to NoSQL and analytical databases.
Estimated Time:2m 0s
Rate this question

Topics

AWS Database Services

More questions from this topic