AWS Certified Data Analytics – Specialty — Question 130

A company uses Amazon Redshift to store its data. The reporting team runs ad-hoc queries to generate reports from the Amazon Redshift database. The reporting team recently started to experience inconsistencies in report generation. Ad-hoc queries used to generate reports that would typically take minutes to run can take hours to run. A data analytics specialist debugging the issue finds that ad-hoc queries are stuck in the queue behind long-running queries.
How should the data analytics specialist resolve the issue?

Answer options

• A. Create partitions in the tables queried in ad-hoc queries.
• B. Configure automatic workload management (WLM) from the Amazon Redshift console.
• C. Create Amazon Simple Queue Service (Amazon SQS) queues with different priorities. Assign queries to a queue based on priority.
• D. Run the VACUUM command for all tables in the database.

Correct answer: B

Explanation

The correct answer is B because configuring automatic workload management (WLM) allows for better handling of different query types and prioritizes resources effectively, which can alleviate the queuing issue for ad-hoc queries. Options A and D may help with performance but do not directly address the queuing problem. Option C involves a different service (Amazon SQS) which is not applicable for query management within Amazon Redshift.