A company has 10-15 ׀¢׀’ 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 option for data format and compression meets these requirements?

A. CSV compressed with zip

B. JSON compressed with bzip2

C. Apache Parquet compressed with Snappy

D. Apache Avro compressed with LZO








 

Suggested Answer: B

Community Answer: C

Reference:
https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-tips-for-amazon-athena/


This question is in DAS-C01 AWS Certified Data Analytics – Specialty Exam
For getting AWS Certified Data Analytics – Specialty Certificate



Disclaimers:
The 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.
The website does not contain actual questions and answers from Amazon's Certification Exam.