ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Data Analytics - Specialty All Questions

View all questions & answers for the AWS Certified Data Analytics - Specialty exam
Go to Exam

Exam AWS Certified Data Analytics - Specialty topic 1 question 150 discussion

Exam question from Amazon's AWS Certified Data Analytics - Specialty
Question #: 150
Topic #: 1
[All AWS Certified Data Analytics - Specialty Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by rb39 at April 21, 2022, 12:56 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Teraxs
Highly Voted 3 years ago
Selected Answer: B
Amazon Redshift workload management (WLM) enables users to flexibly manage priorities within workloads so that short, fast-running queries won't get stuck in queues behind long-running queries. from https://docs.aws.amazon.com/redshift/latest/dg/c_workload_mngmt_classification.html
upvoted 7 times
...
pk349
Most Recent 2 years ago
B: I passed the test
upvoted 1 times
...
rocky48
2 years, 9 months ago
Selected Answer: B
Answer should be B
upvoted 2 times
...
arboles
2 years, 10 months ago
Selected Answer: B
for sure
upvoted 1 times
...
Ramshizzle
2 years, 11 months ago
Selected Answer: B
B is the correct answer. It is the Redshift method for queueing queries.
upvoted 1 times
...
Bik000
2 years, 11 months ago
Selected Answer: B
I think Answer should be B
upvoted 1 times
...
jrheen
3 years ago
B- Correct
upvoted 1 times
...
rb39
3 years ago
Selected Answer: B
Configure automatic workload management (WLM) from the Amazon Redshift console.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago