Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 18 discussion

B. Turn on concurrency scaling at the workload management (WLM) queue level in the Redshift cluster. Explanation: Concurrency scaling in Amazon Redshift allows the cluster to automatically add and remove compute resources in response to workload demands. Enabling concurrency scaling at the workload management (WLM) queue level allows you to specify which queues can benefit from concurrency scaling based on the query workload.

Concurrency Scaling in Amazon Redshift is a feature that automatically adds temporary clusters to handle spikes in query traffic, providing additional read and write capacity. This feature is enabled through Workload Management (WLM) at the queue level in Redshift. Each queue can be configured to use concurrency scaling for handling queries that exceed the capacity of the main cluster. Why option A is incorrect: Turn on concurrency scaling in workload management (WLM) for Redshift Serverless workgroups: This option is for Redshift Serverless rather than clusters on RA3 nodes. Serverless clusters handle scaling differently and don't require manual concurrency scaling settings like the RA3 clusters.

B"You can manage which queries are sent to the concurrency-scaling cluster by configuring WLM queues. You're charged for concurrency-scaling clusters only for the time they're actively running queries." https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html

Selected answer: B B. According to documentation, the "concurrency scaling" is set up in workload management queue (see comment below). A. discarted, because redshift serverless scales automatically (it doesn't need enable "concurrency scaling").

B. Turn on concurrency scaling at the workload management (WLM) queue level in the Redshift cluster.

Answer is B. B. Turn on concurrency scaling at the workload management (WLM) queue level in the Redshift cluster.

https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling-queues.html