Dashboard queries spike unpredictably at month-end — the warehouse gets slow for ~2 days. Which Redshift feature adds transient capacity on demand?
A.Resize the cluster permanently
Permanent resize over-provisions for a 2-day spike.
B.Concurrency scaling
Burst capacity on demand = concurrency scaling. Correct.
C.Read replicas
Redshift doesn't use read replicas — that's Aurora/RDS.
D.RA3 managed storage scaling
Managed storage handles data volume, not query concurrency.
Why this answer
Concurrency scaling adds transient cluster capacity automatically when queries queue — billed per-second (with a free daily allowance). Resizing is permanent and disruptive; RA3 separates storage from compute but doesn't add burst query capacity.
Correct answer: B · Last reviewed 2026-11-05
Official AWS references
Practice this interactively
Answer without seeing the solution first in the Data Stores & Lakes practice session.
Practice Data Stores & Lakes