Exam AWS Certified Solutions Architect - Professional SAP-C02 topic 1 question 305 discussion

D is right Concurrency Scaling is a feature in Amazon Redshift that allows you to scale your cluster's concurrency level up or down based on usage, without having to manually resize the cluster. By turning on Concurrency Scaling, the cluster will automatically scale up when CPU utilization reaches a certain threshold (in this case, 80%), and then scale back down when usage returns to normal. This allows you to meet unexpected bursts of usage while keeping costs under control. This solution meets the business requirements by ensuring that read and write queries can be serviced at all times, while also being cost-effective.

“ With the Concurrency Scaling feature, you can support thousands of 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.” https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html

Answer C

Best option is D

The most cost-effective solution for addressing bursts of usage and accommodating complex queries in Amazon Redshift is to turn on the Concurrency Scaling feature for the Amazon Redshift cluster.

Simply D

https://aws.amazon.com/blogs/big-data/scale-amazon-redshift-to-meet-high-throughput-query-requirements/#:~:text=Use%20concurrency%20scaling%20to%20dynamically,data%20warehouse%20using%20Amazon%20Redshift.

Answer: D The most cost-effective solution for addressing bursts of usage and accommodating complex queries in Amazon Redshift is to turn on the Concurrency Scaling feature for the Amazon Redshift cluster.