AWS Certified Data Engineer – Associate (DEA-C01) — Question 4

A company uses Amazon Athena for one-time queries against data that is in Amazon S3. The company has several use cases. The company must implement permission controls to separate query processes and access to query history among users, teams, and applications that are in the same AWS account.
Which solution will meet these requirements?

Answer options

• A. Create an S3 bucket for each use case. Create an S3 bucket policy that grants permissions to appropriate individual IAM users. Apply the S3 bucket policy to the S3 bucket.
• B. Create an Athena workgroup for each use case. Apply tags to the workgroup. Create an IAM policy that uses the tags to apply appropriate permissions to the workgroup.
• C. Create an IAM role for each use case. Assign appropriate permissions to the role for each use case. Associate the role with Athena.
• D. Create an AWS Glue Data Catalog resource policy that grants permissions to appropriate individual IAM users for each use case. Apply the resource policy to the specific tables that Athena uses.

Correct answer: B

Explanation

The correct answer is B because creating an Athena workgroup allows for distinct permission controls and query history management for different use cases. The other options, while they provide ways to manage access, do not specifically address the need for separating query processes and tracking history within the context of Athena workgroups.