Examkin

Question

Difficulty: MediumAWS Database Services

A marketing analytics firm is migrating its platform to AWS. The firm requires a database solution that can perform complex analytical queries on petabyte-scale historical data to generate trend reports. Additionally, they need to implement a database caching layer to provide sub-millisecond query response times for frequently viewed dashboards. Which TWO AWS services should the firm use to meet these requirements? (Select TWO.)

  1. Amazon RedshiftAnswer
  2. Amazon ElastiCacheAnswer
  3. C
    Amazon DynamoDB
  4. D
    Amazon RDS
  5. E
    Amazon Neptune

Answer

Amazon Redshift and Amazon ElastiCache are the correct services for petabyte-scale data warehousing and sub-millisecond database caching, respectively.
Amazon Redshift is the ideal service for data warehousing and performing complex analytical queries on massive, petabyte-scale datasets. Amazon ElastiCache provides the required database caching layer, storing frequently accessed data in-memory to achieve sub-millisecond query response times.

Step-by-Step Solution

1
Identify the data warehousing requirement.
Amazon Redshift is identified as the optimized AWS service for running complex analytical queries on petabyte-scale historical datasets.
Relational databases (RDS) are optimized for transactional workloads (OLTP), while Redshift is designed specifically for analytics and data warehousing (OLAP).
2
Identify the database caching requirement.
Amazon ElastiCache is selected to store frequently accessed query results in-memory.
ElastiCache provides sub-millisecond response times by retrieving data from in-memory caches rather than querying disk-based databases repeatedly.

Key Concept

Selecting appropriate AWS database services based on workload characteristics (analytical vs. caching).
Rate this question

Topics

AWS Database Services

More questions from this topic