DEA-C01 · Question #83
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…
The correct answer is C. Change the data format from .csv to Apache Parquet. Apply Snappy compression. 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.
Question
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?
Options
- AChange the data format from .csv to JSON format. Apply Snappy compression.
- BCompress the .csv files by using Snappy compression.
- CChange the data format from .csv to Apache Parquet. Apply Snappy compression.
- DCompress the .csv files by using gzip compression.
How the community answered
(25 responses)- A8% (2)
- B4% (1)
- C84% (21)
- D4% (1)
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.
Topics
Community Discussion
No community discussion yet for this question.