A Company Leverages Amazon Athena for Ad-Hoc Queries Against Data

question 19

Multiple Choice

A company leverages Amazon Athena for ad-hoc queries against data stored in Amazon S3. The company wants to implement additional controls to separate query execution and query history among users, teams, or applications running in the same AWS account to comply with internal security policies. Which solution meets these requirements?

• A) Create an S3 bucket for each given use case, create an S3 bucket policy that grants permissions to appropriate individual IAM users. and apply the S3 bucket policy to the S3 bucket.
• B) Create an Athena workgroup for each given use case, apply tags to the workgroup, and create an IAM policy using the tags to apply appropriate permissions to the workgroup.
• C) Create an IAM role for each given use case, assign appropriate permissions to the role for the given use case, and add the role to associate the role with Athena.
• D) Create an AWS Glue Data Catalog resource policy for each given use case that grants permissions to appropriate individual IAM users, and apply the resource policy to the specific tables used by Athena.

---

Definitions:

IR Absorption

The process where molecules absorb specific frequencies of infrared light, causing molecular vibrations that are characteristic of functional groups within the molecule.

Broad Absorption

A phenomenon where a material or molecule absorbs a wide range of wavelengths or frequencies.

IR

Short for Infrared Spectroscopy, a technique used to identify and study chemicals by analyzing the infrared light absorbed by molecules.

Carbonyl

A functional group characterized by a carbon atom double-bonded to an oxygen atom (C=O), central to many organic reactions and compounds.