DEA-C01 · Question #92
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 runt
The correct answer is C. Apache Parquet format compressed with Snappy. 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 si
Question
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?
Options
- A.csv format compressed with zip
- BJSON format compressed with bzip2
- CApache Parquet format compressed with Snappy
- DApache Avro format compressed with LZO
How the community answered
(61 responses)- A10% (6)
- B3% (2)
- C85% (52)
- D2% (1)
Explanation
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.
Topics
Community Discussion
No community discussion yet for this question.