An analytics team needs to run complex SQL joins and aggregations over terabytes-to-petabytes of structured data for BI dashboards. Which service is designed for this workload?
A.Amazon RDS
RDS handles OLTP workloads; it's not optimized for large analytic scans.
B.Amazon DynamoDB
DynamoDB is key-value NoSQL for item-level access, not SQL analytics.
C.Amazon Redshift
Correct. Redshift is the dedicated analytics warehouse.
D.Amazon ElastiCache
ElastiCache is an in-memory cache, not an analytics store.
Why this answer
Amazon Redshift is the petabyte-scale, columnar data warehouse built for analytic SQL (OLAP) — massive parallel query execution, result caching, and BI tool integrations.
Correct answer: C · Last reviewed 2026-10-26
Official AWS references
Practice this interactively
Answer without seeing the solution first in the Data Stores & Lakes practice session.
Practice Data Stores & Lakes