Exam AWS Certified Data Analytics - Specialty topic 1 question 32 discussion

Exam question from Amazon's AWS Certified Data Analytics - Specialty

Question #: 32
Topic #: 1

[All AWS Certified Data Analytics - Specialty Questions]

A company has a data warehouse in Amazon Redshift that is approximately 500 TB in size. New data is imported every few hours and read-only queries are run throughout the day and evening. There is a particularly heavy load with no writes for several hours each morning on business days. During those hours, some queries are queued and take a long time to execute. The company needs to optimize query execution and avoid any downtime.
What is the MOST cost-effective solution?

A. Enable concurrency scaling in the workload management (WLM) queue.
B. Add more nodes using the AWS Management Console during peak hours. Set the distribution style to ALL.
C. Use elastic resize to quickly add nodes during peak times. Remove the nodes when they are not needed.
D. Use a snapshot, restore, and resize operation. Switch to the new target cluster.

Show Suggested Answer

Suggested Answer: A 🗳️

by awssp12345 at Aug. 24, 2020, 4:07 a.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

awssp12345

Highly Voted 3 years, 9 months ago

Answer A is correct- https://docs.aws.amazon.com/redshift/latest/dg/cm-c-implementing-workload-management.html

upvoted 28 times

...

Thiya

Highly Voted 3 years, 7 months ago

Answer: A WLM Concurrency scaling feature automatically adds additional capacity for both read and write queries and charged only for the duration the queries are actively running. Hence, it is the cost-effective approach. https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html

upvoted 10 times

...

GCPereira

Most Recent 1 year, 6 months ago

Easy question, A any througs? Through workload management, you can prioritize queries and define execution patterns across your cluster... resizing, snapshot, or other solutions in these answers is a bit expansive and ineffective.

upvoted 2 times

...

pk349

2 years, 2 months ago

A: I passed the test

upvoted 4 times

...

AwsNewPeople

2 years, 4 months ago

Selected Answer: A

A. Enable concurrency scaling in the workload management (WLM) queue is the most cost-effective solution. Enabling concurrency scaling in the workload management (WLM) queue allows Amazon Redshift to add more cluster capacity to handle the increased query load during peak hours. This is done automatically and can be configured based on the number of users or the number of queries. Concurrency scaling can be turned off during off-peak hours to save costs. This is a more cost-effective solution compared to adding more nodes or using elastic resize, which can be more expensive and take longer to configure. Snapshot, restore, and resize operations can also be time-consuming and may result in downtime.

upvoted 1 times

...

cloudlearnerhere

2 years, 8 months ago

Selected Answer: A

Correct answer is A as Redshift Concurrency Scaling can help scale the cluster to support virtually unlimited concurrent users and queries. Options B, C & D are wrong as they scale the cluster by adding resources that would not be cost-effective.

upvoted 2 times

...