DJames617 Service Comparison
Athena vs Redshift
Serverless S3 SQL and managed warehouse analytics are not the same workload.
What They Have in Common
Each option can solve part of the scenario. The exam expects you to choose the one that satisfies the stated constraints with the right operational burden, security boundary, availability model, and cost behavior.
Key Differences
| Option | Primary model | Best use | Security | Availability | Operations and cost |
|---|---|---|---|---|---|
| Athena | Serverless SQL over S3 | Ad hoc queries, logs, data lake exploration | IAM, Lake Formation, S3/KMS policies | Managed query service; S3 durability applies to data | Pay by scanned data; optimize partitions and formats |
| Redshift | Data warehouse | High-performance BI, complex joins, concurrency, modeled analytics | VPC, IAM, KMS, database and network controls | Managed cluster with snapshot and failover options | Capacity/storage cost; operate sizing, loading, and tuning |
Typical Exam Clues
Practice After Studying
Return to the certification guide that includes this comparison and launch domain training from there.