AWS Certified Data Analytics – Specialty DAS-C01 – Question002

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?

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:

Explanation:
Short query acceleration (SQA) prioritizes selected short-running queries ahead of longer-running queries. SQA executes short-running queries in a dedicated space, so that SQA queries aren’t forced to wait in queues behind longer queries.
Reference: https://docs.aws.amazon.com/redshift/latest/mgmt/workload-mgmt-config.html