Free DATA-ENGINEER-ASSOCIATE Web TestEngine Demo

Exit VCEDump DATA-ENGINEER-ASSOCIATE AWS Certified Data Engineer - Associate (DEA-C01)

Q51 Single choice

An analytics workload in Athena scans several terabytes of CSV files each day. Most queries read only a few columns and filter by event_date. The team wants to reduce scanned data and improve query performance.

Which data layout should the data engineer choose?

A
Convert the data to Apache Parquet and partition the S3 layout by event_date.
B
Combine all CSV files into one uncompressed file in a single S3 prefix.
C
Convert the data to JSON and remove all partition prefixes.
D
Store the data in plain text files with random object key prefixes only.

Previous Check answer

Question map51 / 61

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61

Current Correct Answered Incorrectly Reviewed 0 Remaining 61

Marked Questions0

No marked questions.

Answered Incorrectly0

No incorrect answers.

DATA-ENGINEER-ASSOCIATE Web TestEngine demo