Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 242 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 242
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

A data engineer notices slow query performance on a highly partitioned table that is in Amazon Athena. The table contains daily data for the previous 5 years, partitioned by date.

The data engineer wants to improve query performance and to automate partition management.

Which solution will meet these requirements?

A. Use an AWS Lambda function that runs daily. Configure the function to manually create new partitions in AWS Glue for each day’s data.
B. Use partition projection in Athena. Configure the table properties by using a date range from 5 years ago to the present.
C. Reduce the number of partitions by changing the partitioning schema from daily to monthly granularity.
D. Increase the processing capacity of Athena queries by allocating more compute resources.

Show Suggested Answer

Suggested Answer: B 🗳️

by rdiaz at July 4, 2025, 7:17 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

rdiaz

1 month, 2 weeks ago

Selected Answer: B

Partition projection in Amazon Athena improves performance and eliminates the need to manually manage partitions. It allows Athena to calculate partition values dynamically at query time, rather than relying on a metadata catalog lookup for every partition. This is particularly effective for highly partitioned tables, such as those with daily partitions over multiple years (i.e., 1,800+ partitions in this case). It reduces query planning time and improves performance.

upvoted 1 times

...