AWS Certified Data Engineer – AssociateData Storage and ManagementMedium
A financial services company needs to store transactional data from various source systems. This data is critical, highly structured, and requires strict ACID (Atomicity, Consistency, Isolation, Durability) compliance. The data volume is expected to grow to several terabytes, and the application requires high-performance, low-latency queries and strong transactional integrity. Which AWS managed service is the most appropriate for this requirement?
- AAmazon S3
- BAmazon Aurora (PostgreSQL-compatible)
- CAmazon DynamoDB
- DAmazon Redshift
Show answer & explanationAnswer & explanation
Correct answer: B. Amazon Aurora (PostgreSQL-compatible)
Amazon Aurora is a highly performant, fully managed relational database service that offers strong ACID compliance, high availability, and scalability, making it ideal for critical transactional workloads that require strong data integrity and low-latency access to structured data. The PostgreSQL-compatible edition provides familiar SQL capabilities.
Why the other options are wrong
- A. Amazon S3 is object storage, not a transactional database, and does not provide ACID compliance for relational data.
- C. Amazon DynamoDB is a NoSQL database, offering eventual consistency by default (though transactions are available), but it's not typically the first choice for highly structured data requiring strict relational ACID properties.
- D. Amazon Redshift is a data warehouse optimized for analytical queries, not for high-volume, low-latency transactional workloads requiring strict ACID compliance.
Amazon Aurora
Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, combining the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open-source databases.
- Fully managed relational database service.
- High performance and scalability.
- Strict ACID compliance.
- Highly available with self-healing storage.
- Compatible with MySQL and PostgreSQL.
Memory trick: Aurora's core, for transactions galore, ACID compliance and so much more.