nerdexam
Amazon

SAP-C02 · Question #114

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…

The correct answer is D. Turn on the Concurrency Scaling feature for the Amazon Redshift duster. Support virtually unlimited concurrent users and concurrent queries, with consistently fast query 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…

Submitted by lukas.cz· Mar 6, 2026Continuous Improvement for Existing Solutions

Question

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?

Options

  • AProvision an Amazon EMR duster Offload the complex data processing tasks
  • BDeploy an AWS Lambda function to add capacity to the Amazon Redshift cluster by using a
  • CDeploy an AWS Lambda function to add capacity to the Amazon Redshift duster by using an
  • DTurn on the Concurrency Scaling feature for the Amazon Redshift duster

How the community answered

(33 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    9% (3)
  • D
    85% (28)

Explanation

Support virtually unlimited concurrent users and concurrent queries, with consistently fast query 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. https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html

Community Discussion

No community discussion yet for this question.

Full SAP-C02 Practice