AWS Certified Data Analytics – Specialty — Question 62

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?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because it allows for setting a specific control limit for each query within individual workgroups, ensuring that queries do not exceed the prescribed threshold. Option A suggests using AWS Lambda, which is not necessary for this requirement. Option C is incorrect as S3 bucket policies do not directly manage Athena query limits, and Option D refers to a workgroup-wide limit instead of individual query limits.