AmazonAmazon
DEA-C01 · Question #252
DEA-C01 Question #252: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #252. The question stem and answer options stay visible for context.
Data Store Management
Question
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?
Options
- AUse an AWS Lambda function that runs daily. Configure the function to manually create new
- BUse partition projection in Athena. Configure the table properties by using a date range from 5
- CReduce the number of partitions by changing the partitioning schema from daily to monthly
- DIncrease the processing capacity of Athena queries by allocating more compute resources.
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Athena#Partition Projection#Query Performance Optimization#Partition Management