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 11 discussion

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

Question #: 11
Topic #: 1

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

A data engineer needs Amazon Athena queries to finish faster. The data engineer notices that all the files the Athena queries use are currently stored in uncompressed .csv format. The data engineer also notices that users perform most queries by selecting a specific column.
Which solution will MOST speed up the Athena query performance?

A. Change the data format from .csv to JSON format. Apply Snappy compression.
B. Compress the .csv files by using Snappy compression.
C. Change the data format from .csv to Apache Parquet. Apply Snappy compression.
D. Compress the .csv files by using gzip compression.

Show Suggested Answer

Suggested Answer: C 🗳️

by milofficial at Jan. 18, 2024, 9:47 a.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

milofficial

Highly Voted 1 year, 7 months ago

Selected Answer: C

If the exam would only have these kinds of questions everyone would be blessed

upvoted 12 times

[Removed]

1 year, 7 months ago

Hahahaha! I believe that this kind of question is only for the beta calibration purpose. They won't be in the final exam version.

upvoted 1 times

...

TonyStark0122

Highly Voted 1 year, 6 months ago

C. Change the data format from .csv to Apache Parquet. Apply Snappy compression. Explanation: Apache Parquet is a columnar storage format optimized for analytical queries. It is highly efficient for query performance, especially when queries involve selecting specific columns, as it allows for column pruning and predicate pushdown optimizations.

upvoted 6 times

...

vasimahamed

Most Recent 1 month, 2 weeks ago

Selected Answer: C

C is correct

upvoted 1 times

...

younux

1 month, 2 weeks ago

Selected Answer: C

C is correct

upvoted 1 times

...

Scotty_Nguyen

4 months, 4 weeks ago

Selected Answer: C

C is correct

upvoted 1 times

...

GabrielSGoncalves

1 year ago

Selected Answer: C

C is the way to do It based on best practices recommended by AWS (https://aws.amazon.com/pt/blogs/big-data/top-10-performance-tuning-tips-for-amazon-athena/)

upvoted 1 times

...

hnk

1 year, 3 months ago

Selected Answer: C

C is correct

upvoted 1 times

...

k350Secops

1 year, 3 months ago

Selected Answer: C

switching to Apache Parquet format with Snappy compression offers the most significant improvement in Athena query performance, especially for queries that select specific columns

upvoted 1 times

...