DEA-C01 · Question #70
DEA-C01 Question #70: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #70. The question stem and answer options stay visible for context.
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.)
Options
- ACreate an AWS Glue partition index. Enable partition filtering.
- BBucket the data based on a column that the data have in common in a WHERE clause of the user
- CUse Athena partition projection based on the S3 bucket prefix.
- DTransform the data that is in the S3 bucket to Apache Parquet format.
- EUse the Amazon EMR S3DistCP utility to combine smaller objects in the S3 bucket into larger
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.