AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 242

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?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Use partition projection in Athena. Configure the table properties by using a date range from 5 years ago to the present. Amazon Athena runs serverless SQL queries directly on data in Amazon S3 with no infrastructure to manage. AWS Config tracks resource configuration changes and evaluates compliance.

AWS Certified Data Engineer - Associate DEA-C01 — Question 242