An architect is designing a data warehouse solution using Amazon Redshift. The data warehouse will be queried by multiple business intelligence dashboards. During peak business hours, the number of concurrent queries spikes, causing performance degradation. What is the MOST cost-effective way to handle these unpredictable spikes?

Answer options:

Resize the Redshift cluster to a larger instance type.

Enable Concurrency Scaling on the Redshift cluster.

Use Amazon ElastiCache to cache query results.

Migrate the data to Amazon Athena.

How to approach this question

Identify the Redshift feature for handling concurrent query spikes.

Full Answer

B.Enable Concurrency Scaling on the Redshift cluster.✓ Correct

Amazon Redshift Concurrency Scaling automatically adds additional cluster capacity to process an increase in concurrent read queries. It is highly cost-effective as you accrue free credits and only pay per second of usage beyond that.

Common mistakes

Choosing cluster resize, which is slow and expensive.

Question 57 All questions Question 59

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 2

75 questions · hints · full answers · grading

More questions from this exam

Q01A company is setting up a multi-account AWS environment using AWS Organizations. They need to ens...Easy Q02An enterprise needs to connect its on-premises data center to AWS. They require a dedicated, priv...Easy Q03A company wants to share a single AWS Transit Gateway across multiple AWS accounts within their A...Easy Q04An architect needs to design a highly available database architecture that spans multiple AWS Reg...Easy Q05A global financial institution is migrating its core banking application to AWS. The application ...Medium

View all 75 questions →