DAS-C01 · Question #179
DAS-C01 Question #179: Real Exam Question with Answer & Explanation
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #179. The question stem and answer options stay visible for context.
Question
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?
Options
- ACreate partitions in the tables queried in ad-hoc queries.
- BConfigure automatic workload management (WLM) from the Amazon Redshift console.
- CCreate Amazon Simple Queue Service (Amazon SQS) queues with different priorities. Assign queries to
- DRun the VACUUM command for all tables in the database.
Unlock DAS-C01 to see the answer
You've previewed enough free DAS-C01 questions. Unlock DAS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.