Examkin

Question

Difficulty: MediumAWS Database Services

A retail company is building a business intelligence platform to analyze customer purchasing patterns over the last five years. The system must perform complex, multi-table analytical queries on massive volumes of aggregated transactional data to generate weekly reports. Which AWS database service is specifically designed to support this type of online analytical processing (OLAP) workload?

  1. A
    Amazon DynamoDB
  2. B
    Amazon ElastiCache
  3. Amazon RedshiftAnswer
  4. D
    Amazon EC2 with a self-installed database

Answer

Amazon Redshift
Amazon Redshift is a fully managed, petabyte-scale data warehouse service designed specifically for complex analytical and business intelligence workloads. It uses columnar storage and massive parallel processing (MPP) to query large datasets efficiently.

Step-by-Step Solution

1
Analyze the workload requirements: the system needs to perform complex, multi-table analytical queries on massive volumes of historical sales data.
Identified the workload as Online Analytical Processing (OLAP) rather than Online Transactional Processing (OLTP).
This helps narrow down the database service type to data warehousing solutions.
2
Evaluate the capabilities of the database options against the OLAP requirements.
Determined that Amazon Redshift is the optimized, fully managed AWS data warehouse designed specifically for OLAP.
Amazon DynamoDB is NoSQL, Amazon ElastiCache is for caching, and Amazon EC2 is a self-managed virtual machine, leaving Amazon Redshift as the correct fit.

Key Concept

AWS Database Services
Rate this question

Topics

AWS Database Services

More questions from this topic