AWS Certified Data Engineer – AssociateData Storage and ManagementEasy
A financial services company needs to store transactional data from various source systems. This data is highly structured, requires ACID compliance, and must support complex SQL queries for reporting and analytics. The data volume is expected to grow to several terabytes within a year, and high availability is paramount. Which AWS service is the most suitable choice?
- AAmazon Aurora PostgreSQL-Compatible Edition
- BAmazon DynamoDB
- CAmazon S3 Glacier Deep Archive
- DAmazon Redshift
Show answer & explanationAnswer & explanation
Correct answer: A. Amazon Aurora PostgreSQL-Compatible Edition
Amazon Aurora PostgreSQL-Compatible Edition provides a highly available, ACID-compliant relational database that supports complex SQL queries, making it ideal for structured transactional data with high availability requirements.
Why the other options are wrong
- B. DynamoDB is a NoSQL database, not designed for complex SQL queries or strict ACID compliance across multiple tables.
- C. S3 Glacier Deep Archive is for long-term archival with very slow retrieval times, completely unsuitable for operational transactional data.
- D. Redshift is a data warehouse for analytical workloads, not optimized for transactional data requiring strict ACID compliance for individual transactions.
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.
- Relational database service
- ACID compliant
- High performance and scalability
- Compatible with MySQL and PostgreSQL
Memory trick: ACID needs Aurora, Analytics needs Redshift, NoSQL needs DynamoDB.