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

Exam question from Amazon's AWS Certified Data Analytics - Specialty

Question #: 73
Topic #: 1

[All AWS Certified Data Analytics - Specialty Questions]

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

Suggested Answer: B 🗳️

by awssp12345 at Aug. 29, 2020, 10: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

Submit Cancel

lostsoul07

Highly Voted 3 years, 7 months ago

B is the right answer

upvoted 20 times

...

syu31svc

Highly Voted 3 years, 7 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 2 years, 1 month ago

B: I passed the test

upvoted 1 times

...

cloudlearnerhere

2 years, 7 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, 10 months ago

Selected Answer: B

upvoted 1 times

...

Bik000

3 years ago

Selected Answer: B

Answer is B

upvoted 2 times

...

Marvel_jarvis

3 years, 6 months ago

why not A or C? Can we set RecordMaxBufferTime to control scan?

upvoted 1 times

...

aws2019

3 years, 7 months ago

B is the right answer

upvoted 1 times

...

Donell

3 years, 7 months ago

Answer B

upvoted 1 times

...

Starboy

3 years, 7 months ago

B is the right answer

upvoted 3 times

...

AjNapa

3 years, 8 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, 8 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, 8 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

...