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
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