exam questions

Exam AWS Certified Solutions Architect - Professional All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional exam

Exam AWS Certified Solutions Architect - Professional topic 1 question 866 discussion

A data analytics company has an Amazon Redshift cluster that consists of several reserved nodes. The cluster is experiencing unexpected bursts of usage because a team of employees is compiling a deep audit analysis report. The queries to generate the report are complex read queries and are CPU intensive.
Business requirements dictate that the cluster must be able to service read and write queries at all times. A solutions architect must devise a solution that accommodates the bursts of usage.
Which solution meets these requirements MOST cost-effectively?

  • A. Provision an Amazon EMR cluster. Offload the complex data processing tasks.
  • B. Deploy an AWS Lambda function to add capacity to the Amazon Redshift cluster by using a classic resize operation when the cluster's CPU metrics in Amazon CloudWatch reach 80%.
  • C. Deploy an AWS Lambda function to add capacity to the Amazon Redshift cluster by using an elastic resize operation when the cluster's CPU metrics in Amazon CloudWatch reach 80%
  • D. Turn on the Concurrency Scaling feature for the Amazon Redshift cluster.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Alexey79
Highly Voted 2 years, 7 months ago
Selected Answer: D
https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html “ support virtually unlimited concurrent users and concurrent queries, with consistently fast query performance. When you turn on concurrency scaling, Amazon Redshift automatically adds additional cluster capacity to process an increase in both read and write queries. Users see the most current data, whether the queries run on the main cluster or a concurrency-scaling cluster. You're charged for concurrency-scaling clusters only for the time they're actively running queries. “
upvoted 11 times
...
Bigbearcn
Highly Voted 2 years, 7 months ago
It's C. Elastic resize for Redshift cluster to add nodes. https://aws.amazon.com/cn/blogs/big-data/scale-your-amazon-redshift-clusters-up-and-down-in-minutes-to-get-the-performance-you-need-when-you-need-it/
upvoted 9 times
...
devilman222
Most Recent 4 months, 2 weeks ago
Can someone tell me how the answer that is marked correct is done so. In so many of these the one marked correct is wrong or at least there is complete agreement that another answer is correct. Correct Answer A, but everyone says D. Amazon docs day D or maybe C.
upvoted 1 times
...
gnic
2 years, 3 months ago
Selected Answer: D
It's D. Resizing will get cluster unavailable for few minutes, and question ask for run query all the time.
upvoted 1 times
...
AYANtheGLADIATOR
2 years, 3 months ago
D is the answer for sure.
upvoted 1 times
...
Enigmaaaaaa
2 years, 4 months ago
Selected Answer: D
Only D is valid since reserved instances were bought - scaling down the cluster will not help to save cost.
upvoted 3 times
...
aandc
2 years, 5 months ago
Selected Answer: D
Vote D since concurrency-scaling has free credits "Concurrency Scaling credits Redshift clusters earn up to one hour of free Concurrency Scaling credits per day. Credits are earned on an hourly basis for each active cluster in your AWS account, and can be consumed by the same cluster only after credits are earned. You can accumulate up to 30 hours of free Concurrency Scaling credits for each active cluster. Credits do not expire as long as your cluster is not terminated."
upvoted 2 times
...
bobsmith2000
2 years, 7 months ago
Selected Answer: D
Key phrases: "numerous reserved nodes" - adding or deleting don't seem to be an option "cost-effectiveness" Between C and D C - https://docs.aws.amazon.com/redshift/latest/mgmt/managing-cluster-operations.html#elastic-resize D - https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html As to me D makes more sense. It doesn't cause a cluster unavailability and aws charges you for concurrency-scaling clusters only for the time they're actively running queries.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...