Q19Data Store Management
A company uses an Amazon Redshift cluster that runs on RA3 nodes. The company wants to scale read and write capacity to meet demand. A data engineer needs to identify a solution that will turn on concurrency scaling. Which solution will meet this requirement?
← → navigate · a answer
Community votes
Discussion · 7
9
B. Enable concurrency scaling at the workload management (WLM) queue level in the Redshift cluster.
Explanation:
Concurrency scaling in Amazon Redshift lets the cluster automatically add and remove compute resources based on workload demand. Turning on concurrency scaling at the workload management (WLM) queue level lets you choose which queues can take advantage of concurrency scaling depending on the query workload.
B 4
Selected Answer: B
https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling-queues.html
B 4
Selected Answer: B
Concurrency Scaling in Amazon Redshift is a feature that automatically adds temporary clusters to handle spikes in query traffic, giving extra 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 go beyond 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 instead of clusters on RA3 nodes. Serverless clusters scale differently and don't need manual concurrency scaling settings like RA3 clusters.
B 2
Selected answer: B
B. Based on the documentation, the "concurrency scaling" is configured in the workload management queue (see comment below).
A. discarted, because redshift serverless scales automatically (it doesn't need enable "concurrency scaling").
B 1
Selected Answer: B
Answer is B.
B. Enable concurrency scaling at the workload management (WLM) queue level in the Redshift cluster.
B 1
Selected Answer: B
B. Enable concurrency scaling at the workload management (WLM) queue level in the Redshift cluster.
1
B"You can control 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