nerdexam
Amazon

SOA-C02 · Question #715

A company is using Amazon S3 buckets to store datasets. The company has several teams that use Amazon Athena to run one-time queries against the datasets. A SysOps administrator must implement a…

The correct answer is A. Create individual Athena workgroups that have separate S3 query result locations. Create a separate Athena workgroup for each team and set its own S3 query result location. Workgroups enforce and isolate result output paths, ensuring every team’s results land in its designated bucket automatically.

Submitted by kevin_r· Mar 30, 2026Cost and Performance Optimization

Question

A company is using Amazon S3 buckets to store datasets. The company has several teams that use Amazon Athena to run one-time queries against the datasets. A SysOps administrator must implement a solution that stores each team’s Athena query results in that team’s individual S3 bucket. Which solution will meet this requirement?

Options

  • ACreate individual Athena workgroups that have separate S3 query result locations.
  • BConfigure an AWS Glue Data Catalog database for each team. Instruct the teams to run their
  • CRequire each team to use the primary Athena workgroup. Instruct the teams to set individual S3
  • DCreate an AWS Glue security configuration. Associate the security configuration with each team.

How the community answered

(45 responses)
  • A
    82% (37)
  • B
    11% (5)
  • C
    2% (1)
  • D
    4% (2)

Explanation

Create a separate Athena workgroup for each team and set its own S3 query result location. Workgroups enforce and isolate result output paths, ensuring every team’s results land in its designated bucket automatically.

Topics

#Athena workgroups#query result isolation#S3 output location#team access control

Community Discussion

No community discussion yet for this question.

Full SOA-C02 Practice