Examkin

Question

Difficulty: EasyAWS Database Services

A financial services company needs to perform complex analytical queries on massive collections of historical transaction records to generate business intelligence reports. Which AWS service is a fully managed data warehouse designed specifically for this type of high-performance analytics?

  1. A
    Amazon ElastiCache
  2. B
    Amazon DynamoDB
  3. Amazon RedshiftAnswer
  4. D
    Amazon RDS

Answer

Amazon Redshift is the correct service because it is specifically designed as a fully managed data warehouse for running complex analytical queries on large datasets.
Amazon Redshift is correct because it is a fully managed, petabyte-scale data warehouse service designed specifically for high-performance business intelligence and analytical querying (OLAP).

Step-by-Step Solution

1
Analyze the business requirements in the scenario.
The requirement is to run complex analytical queries on historical transaction data for business intelligence.
Identifying the workload type helps distinguish between transactional (OLTP), NoSQL, and analytical (OLAP) database solutions.
2
Match the analytical database requirement to the appropriate AWS database service.
Amazon Redshift is AWS's dedicated data warehousing service designed for Online Analytical Processing (OLAP).
Other options like Amazon RDS, Amazon DynamoDB, and Amazon ElastiCache are designed for transaction processing, key-value storage, and caching respectively.

Key Concept

AWS Database Services
Rate this question

Topics

AWS Database Services

More questions from this topic