DAS-C01 · Question #104
A retail company leverages Amazon Athena for ad-hoc queries against an AWS Glue Data Catalog. The data analytics team manages the data catalog and data access for the company. The data analytics…
The correct answer is C. Create Athena workgroups for each team within the company. Amazon Athena Workgroups are the purpose-built feature for exactly this use case. Workgroups allow administrators to group users and queries by team, configure separate S3 output locations per workgroup, and enforce data usage controls (e.g., limit the amount of data scanned…
Question
A retail company leverages Amazon Athena for ad-hoc queries against an AWS Glue Data Catalog. The data analytics team manages the data catalog and data access for the company. The data analytics team wants to separate queries and manage the cost of running those queries by different workloads and teams. Ideally, the data analysts want to group the queries run by different users within a team, store the query results in individual Amazon S3 buckets specific to each team, and enforce cost constraints on the queries run against the Data Catalog. Which solution meets these requirements?
Options
- ACreate IAM groups and resource tags for each team within the company.
- BCreate Athena resource groups for each team within the company and assign users to these
- CCreate Athena workgroups for each team within the company.
- DCreate Athena query groups for each team within the company and assign users to the groups.
How the community answered
(66 responses)- A17% (11)
- B3% (2)
- C73% (48)
- D8% (5)
Explanation
Amazon Athena Workgroups are the purpose-built feature for exactly this use case. Workgroups allow administrators to group users and queries by team, configure separate S3 output locations per workgroup, and enforce data usage controls (e.g., limit the amount of data scanned per query or per workgroup). IAM groups (A) control access but cannot enforce Athena-specific cost constraints or set per-team result locations. 'Athena resource groups' (B) and 'Athena query groups' (D) are not real Athena features - these are distractors.
Topics
Community Discussion
No community discussion yet for this question.