AWS Certified Data Analytics – Specialty — Question 147

An online retail company is using Amazon Redshift to run queries and perform analytics on customer shopping behavior. When multiple queries are running on the cluster, runtime for small queries increases significantly. The company's data analytics team to decrease the runtime of these small queries by prioritizing them ahead of large queries.
Which solution will meet these requirements?

Answer options

• A. Use Amazon Redshift Spectrum for small queries
• B. Increase the concurrency limit in workload management (WLM)
• C. Configure short query acceleration in workload management (WLM)
• D. Add a dedicated compute node for small queries

Correct answer: C

Explanation

The correct answer is C because configuring short query acceleration in workload management (WLM) specifically prioritizes small queries, allowing them to complete faster even when larger queries are running. Option A, using Amazon Redshift Spectrum, does not inherently prioritize small queries. Option B, increasing the concurrency limit, may allow more queries to run but does not prioritize smaller queries. Option D, adding a dedicated compute node, could help but does not guarantee prioritization of small queries over larger ones.