SAA-C03 · Question #338
SAA-C03 Question #338: Real Exam Question with Answer & Explanation
The correct answer is C: Enable the concurrency scaling feature for the Redshift cluster for specific workload management. Concurrency Scaling allows Amazon Redshift to add transient capacity automatically to handle bursts in concurrent queries. This is ideal for scenarios with predictable surge periods, such as end-of-month reporting. It improves performance without manual resizing or cluster modifi
Question
A company is using an Amazon Redshift cluster to run analytics queries for multiple sales teams. In addition to the typical workload, on the last Monday morning of each month, thousands of users run reports. Users have reported slow response times during the monthly surge. The company must improve query performance without impacting the availability of the Redshift cluster. Which solution will meet these requirements?
Options
- AResize the Redshift cluster by using the classic resize capability of Amazon Redshift before every
- BResize the Redshift cluster by using the elastic resize capability of Amazon Redshift before every
- CEnable the concurrency scaling feature for the Redshift cluster for specific workload management
- DEnable Amazon Redshift Spectrum for the Redshift cluster before every monthly surge.
Explanation
Concurrency Scaling allows Amazon Redshift to add transient capacity automatically to handle bursts in concurrent queries. This is ideal for scenarios with predictable surge periods, such as end-of-month reporting. It improves performance without manual resizing or cluster modification and without affecting availability. Resizing requires manual intervention and potential downtime, and Redshift Spectrum is designed for querying data in S3, not for solving concurrency issues.
Community Discussion
No community discussion yet for this question.