AWS Certified Data Engineer – Associate (DEA-C01) — Question 12

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?

Answer options

• 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 any new Redshift cluster.
• D. Turn on concurrency scaling for the daily usage quota for the Redshift cluster.

Correct answer: B

Explanation

The correct answer is B because enabling concurrency scaling at the workload management (WLM) queue level directly allows the Redshift cluster to handle increased demand for concurrent queries. Options A, C, and D do not provide the necessary adjustments at the WLM queue level, which is essential for managing concurrency effectively.