AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ266

Data Ingestion and Transformation

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

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

Which file format and compression solution will satisfy 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
Explanation

Apache Parquet is a columnar format optimized for analytical retrieval. Its per-column compression and predicate pushdown reduce S3 storage, I/O, and the data Athena scans, improving query performance and cost. Athena supports Snappy compression for Parquet.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!