Redshift Serverless runs data-warehouse queries without you provisioning or managing a cluster. Capacity scales automatically and you pay for what you use — ideal for variable or unpredictable analytics workloads.
Serverless vs provisioned Redshift
Provisioned Redshift means sizing and paying for a cluster that runs continuously — best for steady, heavy workloads. Serverless spins capacity up and down automatically and charges by usage — best when analytics demand is spiky or intermittent and you don’t want to manage a cluster.
Test yourself
A team has intermittent, unpredictable analytics workloads and doesn’t want to size or manage a Redshift cluster. Which option fits best?
- Provisioned Redshift with a large cluster
- Redshift Serverless
- Amazon RDS
- Provisioned Redshift with reserved nodes
👉 Click to reveal the answer & explanation
Correct answer: B. Redshift Serverless auto-scales capacity and bills by usage — ideal for spiky, intermittent analytics with no cluster management. Provisioned options (A, D) pay for a running cluster suited to steady load; RDS (C) isn’t a data warehouse.
Related topics
Amazon Redshift · Redshift Spectrum · Amazon Athena
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