AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ135

Data Operations and Support

A data engineer wants Amazon Athena queries to complete more quickly. The data engineer observes that every file used by the Athena queries is currently stored as uncompressed .csv data. The data engineer also observes that users run most queries by selecting one particular column.

Which solution will MOST improve 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.
Explanation

Apache Parquet is a columnar storage format optimized for fast analytical retrieval. When queries select a specific column, Athena can read only the relevant column data rather than scanning complete row-oriented CSV records. Parquet also supports column-level compression, reducing data read from Amazon S3; Snappy is optimized for fast compression and decompression. AWS: Use columnar storage formats

Learn more

Community Discussion

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