Examkin

Question

Difficulty: MediumAWS Database Services

A logistics company is building a package tracking and analytics platform. The platform requires a transactional database to store real-time shipment status updates with relational schemas and SQL support. Additionally, the platform requires an analytical database to perform complex queries on years of historical delivery data for route optimization. Which TWO AWS services should the company select to meet these requirements?

  1. Amazon Relational Database Service (Amazon RDS)Answer
  2. Amazon RedshiftAnswer
  3. C
    Amazon DynamoDB
  4. D
    Amazon ElastiCache
  5. E
    Amazon Simple Storage Service (Amazon S3)

Answer

Amazon Relational Database Service (Amazon RDS) and Amazon Redshift
Amazon Relational Database Service (Amazon RDS) is correct because it is a fully managed service that simplifies the setup, operation, and scaling of relational databases, which perfectly handles the SQL transactional requirements for tracking. Amazon Redshift is correct because it is a managed data warehouse optimized for complex analytics (OLAP) over historical records to support decision-making.

Step-by-Step Solution

1
Identify the transaction (OLTP) database requirement.
The tracking database requires relational schemas, SQL support, and ACID compliance, which points directly to Amazon Relational Database Service (Amazon RDS).
Relational databases are best suited for transactional systems requiring structured data integrity.
2
Identify the analytical (OLAP) database requirement.
The route optimization analytics require complex queries on years of historical delivery data, which points to Amazon Redshift.
Data warehouses are designed specifically to handle large-scale, complex analytical queries efficiently.

Key Concept

Purpose-built databases on AWS (OLTP relational vs. OLAP data warehousing)
Rate this question

Topics

AWS Database Services

More questions from this topic