Which solution will meet this requirement?

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?
A . Turn on concurrency scaling in workload management (WLM) for Redshift Serverless workgroups.
B . Turn on concurrency scaling at the workload management (WLM) queue level in the Redshift cluster.
C . Turn on concurrency scaling in the settings during the creation of and new Redshift cluster.
D . Turn on concurrency scaling for the daily usage quota for the Redshift cluster.

Answer: B

Explanation:

Concurrency scaling is a feature that allows you to support thousands of concurrent users and queries, with consistently fast query performance. When you turn on concurrency scaling, Amazon Redshift automatically adds query processing power in seconds to process queries without any delays. You can manage which queries are sent to the concurrency-scaling cluster by configuring WLM queues. To turn on concurrency scaling for a queue, set the Concurrency Scaling mode value to auto. The other options are either incorrect or irrelevant, as they do not enable concurrency scaling for the existing Redshift cluster on RA3 nodes.

Reference: Working with concurrency scaling – Amazon Redshift Amazon Redshift Concurrency Scaling – Amazon Web Services Configuring concurrency scaling queues – Amazon Redshift

AWS Certified Data Engineer – Associate DEA-C01 Complete Study Guide (Chapter 6, page 163)