AWS Certified Data Analytics – Specialty — Question 49

A company has a data warehouse in Amazon Redshift that is approximately 500 TB in size. New data is imported every few hours and read-only queries are run throughout the day and evening. There is a particularly heavy load with no writes for several hours each morning on business days. During those hours, some queries are queued and take a long time to execute. The company needs to optimize query execution and avoid any downtime.
What is the MOST cost-effective solution?

Answer options

• A. Enable concurrency scaling in the workload management (WLM) queue.
• B. Add more nodes using the AWS Management Console during peak hours. Set the distribution style to ALL.
• C. Use elastic resize to quickly add nodes during peak times. Remove the nodes when they are not needed.
• D. Use a snapshot, restore, and resize operation. Switch to the new target cluster.

Correct answer: A

Explanation

The correct answer is A because enabling concurrency scaling allows additional capacity to handle query loads during peak times without the need for permanent node increases, making it cost-effective. Options B and C involve adding nodes that incur additional costs, while D requires significant effort and resources to set up a new cluster, which is not efficient for just managing query loads.