SAP-C02 Question 303

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 2

  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.

• Chose D3

  “ 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

• 1

  Answer C