exam questions

Exam AWS Certified Data Analytics - Specialty All Questions

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

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

A company's data analyst needs to ensure that queries run in Amazon Athena cannot scan more than a prescribed amount of data for cost control purposes.
Queries that exceed the prescribed threshold must be canceled immediately.
What should the data analyst do to achieve this?

  • A. Configure Athena to invoke an AWS Lambda function that terminates queries when the prescribed threshold is crossed.
  • B. For each workgroup, set the control limit for each query to the prescribed threshold.
  • C. Enforce the prescribed threshold on all Amazon S3 bucket policies
  • D. For each workgroup, set the workgroup-wide data usage control limit to the prescribed threshold.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
lostsoul07
Highly Voted 3 years, 5 months ago
B is the right answer
upvoted 20 times
...
syu31svc
Highly Voted 3 years, 6 months ago
From the link: https://docs.aws.amazon.com/athena/latest/ug/workgroups-setting-control-limits-cloudwatch.html "The per-query control limit specifies the total amount of data scanned per query. If any query that runs in the workgroup exceeds the limit, it is canceled" Answer is B
upvoted 15 times
...
pk349
Most Recent 1 year, 12 months ago
B: I passed the test
upvoted 1 times
...
cloudlearnerhere
2 years, 5 months ago
Selected Answer: B
Correct answer is B as Athena Workgroups help set control limits and per-query control limit helps specific a limit which if exceeded by a query it would be canceled. A is wrong as you can't configure Atehna for this purpose C is incorrect because you can't set a threshold in Athena using S3 bucket policies. D is incorrect because the workgroup-wide data usage control limit specifies the total amount of data scanned for all queries that run in the entire workgroup, and not on a specific query only. Remember that the requirement is to immediately cancel queries that exceed the recommended threshold.
upvoted 8 times
...
rocky48
2 years, 9 months ago
Selected Answer: B
Selected Answer: B
upvoted 1 times
...
Bik000
2 years, 11 months ago
Selected Answer: B
Answer is B
upvoted 2 times
...
Marvel_jarvis
3 years, 4 months ago
why not A or C? Can we set RecordMaxBufferTime to control scan?
upvoted 1 times
...
aws2019
3 years, 5 months ago
B is the right answer
upvoted 1 times
...
Donell
3 years, 5 months ago
Answer B
upvoted 1 times
...
Starboy
3 years, 5 months ago
B is the right answer
upvoted 3 times
...
AjNapa
3 years, 6 months ago
Will go with B for this scenario. I think the use case if to set a per query limit
upvoted 2 times
...
KoMo
3 years, 6 months ago
"per-query control limit" vs "workgroup-wide data usage control limit" https://docs.aws.amazon.com/athena/latest/ug/workgroups-setting-control-limits-cloudwatch.html
upvoted 2 times
...
Paitan
3 years, 6 months ago
B and D both serve similar purpose. However in this example B is the right option. https://docs.aws.amazon.com/athena/latest/ug/workgroups-setting-control-limits-cloudwatch.html
upvoted 3 times
...
jersyl
3 years, 6 months ago
It is B based on this link: https://docs.aws.amazon.com/athena/latest/ug/manage-queries-control-costs-with-workgroups.html
upvoted 3 times
...
awssp12345
3 years, 6 months ago
I apologize, the Answer is B.
upvoted 3 times
...
awssp12345
3 years, 7 months ago
Agree with D.
upvoted 1 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago