nerdexam
AmazonAmazon

SAP-C02 · Question #572

SAP-C02 Question #572: Real Exam Question with Answer & Explanation

The correct answer is D: Turn on the Concurrency Scaling feature for the Amazon Redshift cluster.. 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.

Submitted by anna_se· 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 cluster 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 cluster by using an
  • DTurn on the Concurrency Scaling feature for the Amazon Redshift cluster.

Explanation

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.

Community Discussion

No community discussion yet for this question.

Full SAP-C02 PracticeBrowse All SAP-C02 Questions