Examkin

Question

Difficulty: EasyAWS Database Services

A retail company wants to analyze large volumes of historical sales transaction data to identify long-term shopping trends. The company needs a fully managed service that can run complex SQL queries against petabytes of data and integrate with their business intelligence tools. Which AWS service is designed to meet this requirement?

  1. Amazon RedshiftAnswer
  2. B
    Amazon DynamoDB
  3. C
    Amazon ElastiCache
  4. D
    Amazon Aurora

Answer

Amazon Redshift
Amazon Redshift is correct because it is a managed data warehouse service designed specifically for online analytical processing (OLAP) workloads. It allows users to run complex SQL queries against structured data and integrates seamlessly with common business intelligence tools.

Step-by-Step Solution

1
Identify the primary business need.
The company needs a service to analyze large volumes of historical transaction data using complex SQL queries and BI tool integration.
This requirement indicates an Online Analytical Processing (OLAP) or data warehousing use case.
2
Evaluate the available database service options against this need.
Amazon Redshift is AWS's dedicated data warehousing service designed for SQL-based analytical queries at scale. Other services like DynamoDB, Aurora, and ElastiCache are optimized for transactional, relational, or caching workloads.
Matching the specific workload type to the appropriate database category ensures high performance and correct functionality.

Key Concept

AWS Data Warehousing Services
Rate this question

Topics

AWS Database Services

More questions from this topic