Redshift is Amazon’s data warehouse — built for big analytical queries across huge datasets. Where DynamoDB is fast app lookups and Athena is occasional S3 queries, Redshift is for heavy, repeated business-intelligence workloads on structured data.
The concepts to know
Redshift is a provisioned cluster (you pay while it runs), columnar and massively parallel, with distribution keys and sort keys controlling how data spreads and orders across nodes. Redshift Spectrum queries S3 data without loading it in.
Test yourself
A company runs the same complex analytical reports over terabytes of structured sales data all day, every day. Which service is the best fit?
- Amazon Athena
- Amazon Redshift
- Amazon DynamoDB
- Amazon RDS
👉 Click to reveal the answer & explanation
Correct answer: B. Redshift is a data warehouse built for repeated, heavy analytical queries at scale. Athena (A) suits occasional ad-hoc queries; DynamoDB (C) is for app lookups, not analytics; RDS (D) isn’t built for warehouse-scale BI.
Related topics
Amazon Athena · AWS Glue · Kinesis Data Streams
Ready to pass the AWS Data Engineer Associate (DEA-C01)?
Stop guessing whether you’re ready. Our full-length, exam-realistic practice exams put you through the exact question style you’ll face — with a detailed explanation behind every answer, so you learn why, not just what.
- ✓ 6 full-length practice exams
- ✓ A detailed explanation for every single question
- ✓ Realistic, scenario-based questions — not memory dumps
- ✓ Lifetime access, kept current for 2026
Get the DEA-C01 Practice Exams →or try 25 free questions first