Examkin

Question

Difficulty: MediumAWS Database Services

A logistics company is modernizing its data tier on AWS. The company needs a database solution to handle two distinct requirements: first, storing live, highly structured transaction records for order processing that requires full ACID compliance and SQL joins; second, running complex analytical queries over petabytes of historical tracking data to generate business intelligence reports. Which two AWS database services should the company select to meet these requirements?

  1. Amazon RDSAnswer
  2. Amazon RedshiftAnswer
  3. C
    Amazon DynamoDB
  4. D
    Amazon ElastiCache
  5. E
    Amazon Neptune

Answer

Amazon RDS and Amazon Redshift
The workload involving live, highly structured transactional records requiring ACID compliance is best suited for Amazon RDS, which is a fully managed relational database service. The workload involving analytical queries over petabytes of historical data for business intelligence is best suited for Amazon Redshift, which is a fully managed data warehouse designed specifically for high-performance analysis of massive datasets.

Step-by-Step Solution

1
Analyze the first requirement
The requirement specifies storing live, highly structured transaction records with full ACID compliance and support for SQL joins. This is a classic Online Transaction Processing (OLTP) workload, which is best served by a relational database like Amazon RDS.
Amazon RDS manages relational engines (like PostgreSQL or MySQL) that enforce schema structure and ACID compliance.
2
Analyze the second requirement
The requirement specifies running complex analytical queries over petabytes of historical tracking data for business intelligence. This is an Online Analytical Processing (OLAP) workload, which is best served by a cloud data warehouse like Amazon Redshift.
Amazon Redshift uses columnar storage and parallel processing to analyze massive datasets efficiently.

Key Concept

Distinguishing between relational transactional databases (OLTP) and analytical data warehouses (OLAP) in AWS.
Rate this question

Topics

AWS Database Services

More questions from this topic