Get Your CertDEA-C01PlayCompete
‹ All DEA-C01 questions

DEA-C01 Practice Question 76: Redshift Concurrency Scaling Spikes

AWS Certified Data Engineer – Associate (DEA-C01) · Test 8 · question 6 of 10

Data Store Managementmedium

Every weekday at 8 AM, hundreds of analysts open dashboards at once and queries queue on an Amazon Redshift RA3 cluster. For the rest of the day the cluster is lightly used. The team wants consistent response times during the spike and wants to pay for extra capacity only while it is needed. What should they do?

Select one answer
Show answer and explanation

Answer:

  • C. Turn on concurrency scaling for the workload management queue that the dashboards use.

With concurrency scaling, *"Amazon Redshift automatically adds additional cluster capacity to process an increase in both read and write queries,"* and *"eligible queries are sent to the concurrency-scaling cluster instead of waiting in a queue."* It is enabled per WLM queue by setting the concurrency scaling mode to auto, and *"you're charged for concurrency-scaling clusters only for the time they're actively running queries"* (option C).

- A is wrong because permanent extra nodes are paid for all day, even though the spike lasts only a short time. - B is wrong because a separate database on the same cluster shares the same compute resources. It adds no capacity. - D is wrong because a shorter timeout cancels queries rather than running them. Analysts would see failures instead of faster dashboards.

Reference: Concurrency scaling

Practice Test 8 ›

Study guides for DEA-C01

AWS Developer Associate exam guide: DVA-C02 to DVA-C03AWS Developer Associate exam: DVA-C02 ends 30 November 2026 and DVA-C03 starts 1 December. What changes, which to sit, format, price and study plan.
How AWS Certification Exams Work: Scoring and RenewalHow AWS certification exams work: levels, booking, question types, unscored questions, scaled scores, pass marks, validity and how recertification works.
What Is Amazon RDS? Multi-AZ, Read Replicas and BackupsWhat is Amazon RDS? Engines, Multi-AZ, read replicas, backups, RDS Proxy, Aurora and pricing explained, with the traps that AWS exams set around each one.
Microsoft Fabric certification: DP-700 vs DP-600Microsoft Fabric certification means two exams, DP-600 and DP-700. Their roles, skills, format, cost in India, and which one to take first.
Databricks Data Engineer Associate vs AWS DEA-C01Databricks Data Engineer Associate vs AWS Certified Data Engineer – Associate - format, cost, topics and which one to take for your job, as of 2026.
Which AWS certification should you get? 2026 roadmapWhich AWS certification to get first, by role and experience, with each exam's status in October 2026, what is changing, and prices in USD and INR.
What Is AWS Glue? Data Catalog, Crawlers and ETL JobsWhat is AWS Glue? The Data Catalog, crawlers, ETL jobs and DPUs, workflows, streaming, job bookmarks, Flex and Data Quality, plus the traps AWS exams set.