Amazon

DEA-C01 practice question 8

AWS Certified Data Engineer - Associate (DEA-C01) · free question 8 of 20

Question

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

Explanation

Creating an Athena workgroup for each use case and applying tags to these workgroups allows for granular permission controls based on those tags via IAM policies, as per AWS documentation. This approach ensures separation of query processes and access to query history among users, teams, and applications within the same AWS account.

Need the theory? Learn it free in the DEA-C01 course on Godlike Academy

Practice the whole free set

Answer all 20 free DEA-C01 questions with instant feedback, or unlock all 343 questions with Learn and Exam modes.