Valid DEA-C01 Dumps shared by EduDump.com for Helping Passing DEA-C01 Exam! EduDump.com now offer the newest DEA-C01 exam dumps, the EduDump.com DEA-C01 exam questions have been updated and answers have been corrected get the newest EduDump.com DEA-C01 dumps with Test Engine here:
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?
Correct Answer: B
Partition projection eliminates the need for frequent metadata lookups or explicit partition registration in the AWS Glue Data Catalog. By defining a date range in your table's properties (for example, projection.enabled=true, projection.order_date.type=DATE, projection.order_date.range=2020/01/01,NOW, and the appropriate format), Athena will calculate partitions on-the-fly. This both speeds up queries (avoiding catalog calls for thousands of partitions) and removes the need for any external partition-management jobs.