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

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 18
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

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

Show Suggested Answer

Suggested Answer: B 🗳️

by milofficial at Jan. 20, 2024, 12:02 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

TonyStark0122

Highly Voted 1 year, 5 months ago

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.

upvoted 9 times

...

saransh_001

Most Recent 5 months ago

Selected Answer: B

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.

upvoted 4 times

...

lsj900605

8 months, 1 week ago

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

upvoted 1 times

...

San_Juan

10 months, 4 weeks ago

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").

upvoted 2 times

...