Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 82 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 82
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

A company stores 10 to 15 TB of uncompressed .csv files in Amazon S3. The company is evaluating Amazon Athena as a one-time query engine.

The company wants to transform the data to optimize query runtime and storage costs.

Which file format and compression solution will meet these requirements for Athena queries?

A. .csv format compressed with zip
B. JSON format compressed with bzip2
C. Apache Parquet format compressed with Snappy
D. Apache Avro format compressed with LZO

Show Suggested Answer

Suggested Answer: C 🗳️

by tgv at June 14, 2024, 4:25 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

tgv

Highly Voted 11 months, 1 week ago

Selected Answer: C

Parquet provides efficient columnar storage, enabling Athena to read only the necessary data for queries, which reduces scan times and speeds up query performance. Snappy compression offers a good balance between compression speed and efficiency, reducing storage costs without significantly impacting query times.

upvoted 6 times

...

artworkad

Most Recent 11 months, 1 week ago

Selected Answer: C

Parquet + Snappy

upvoted 3 times

...

Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam

Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 82 discussion

Comments

tgv

artworkad

SY0-701