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

Question

A data engineer runs Amazon Athena queries on data that is in an Amazon S3 bucket. The Athena queries use AWS Glue Data Catalog as a metadata table. The data engineer notices that the Athena query plans are experiencing a performance bottleneck. The data engineer determines that the cause of the performance bottleneck is the large number of partitions that are in the S3 bucket. The data engineer must resolve the performance bottleneck and reduce Athena query planning time. Which solutions will meet these requirements? (Choose two.)

Accepted Answer

Correct answer: A, C. The correct answer is A, C. Option A: Create an AWS Glue partition index. Enable partition filtering. Option C: Use Athena partition projection based on the S3 bucket prefix. Amazon S3 provides durable, scalable object storage that is fully managed. Amazon Athena runs serverless SQL queries directly on data in Amazon S3 with no infrastructure to manage. AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data.

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