DEA-C01 · Question #260
A company needs to use Amazon Athena to analyze data that is in an Amazon S3 bucket. A data engineer needs to configure AWS Glue table partitions for year, month, and day. The data engineer needs to…
The correct answer is C. Set partition projection properties for the AWS Glue table. Partition projection in AWS Glue lets Athena automatically calculate partitions based on table properties without explicitly creating them each day. This eliminates the need for crawlers or Lambda jobs, reduces operational overhead, and adapts to schema changes while supporting…
Question
A company needs to use Amazon Athena to analyze data that is in an Amazon S3 bucket. A data engineer needs to configure AWS Glue table partitions for year, month, and day. The data engineer needs to create the partitions every day to adjust to schema changes in the data. Which solution will meet these requirements?
Options
- AUse AWS Glue DataBrew to create the partitions for the AWS Glue table.
- BUse an AWS Lambda function to create the partitions for the AWS Glue table.
- CSet partition projection properties for the AWS Glue table.
- DConfigure an AWS Glue crawler to run on a set schedule.
How the community answered
(28 responses)- A4% (1)
- B18% (5)
- C71% (20)
- D7% (2)
Explanation
Partition projection in AWS Glue lets Athena automatically calculate partitions based on table properties without explicitly creating them each day. This eliminates the need for crawlers or Lambda jobs, reduces operational overhead, and adapts to schema changes while supporting year, month, and day partitions efficiently.
Topics
Community Discussion
No community discussion yet for this question.