Examkin

Question

Difficulty: MediumAWS Database Services

A company is designing a new e-commerce application. The application requires a transactional database to store customer order history with strict ACID compliance and a relational structure. Additionally, the company needs a data warehousing solution to perform complex analytical queries and business intelligence reporting on years of historical sales data.

Which AWS services should the company use to meet these requirements? (Select TWO.)

  1. Amazon AuroraAnswer
  2. Amazon RedshiftAnswer
  3. C
    Amazon DynamoDB
  4. D
    Amazon ElastiCache
  5. E
    Amazon EBS

Answer

Amazon Aurora and Amazon Redshift are the appropriate services.
Amazon Aurora provides a fully managed relational database engine compatible with MySQL and PostgreSQL, ensuring strict transactional ACID compliance for customer order history. Amazon Redshift is a fast, petabyte-scale data warehouse service that enables complex analytical queries and business intelligence reporting on historical sales data.

Step-by-Step Solution

1
Identify the primary workload requirements.
The first requirement is a relational database with strict ACID compliance for transactional history. The second requirement is a data warehousing service for complex analytical and business intelligence queries.
Analyzing the requirements allows us to map them to the correct category of AWS database services.
2
Select the service that fits the transactional relational database requirement.
Amazon Aurora is selected as the relational database engine because it supports transactional, ACID-compliant data storage.
Relational requirements require structured tables with schema consistency and transaction support.
3
Select the service that fits the analytical data warehousing requirement.
Amazon Redshift is selected because it is built for high-performance analytical queries across large datasets.
Standard transactional databases are not optimized for heavy analytical workloads, which require a dedicated data warehouse.

Key Concept

AWS Database Services
Rate this question

Topics

AWS Database Services

More questions from this topic