Question 1. A team stores several terabytes of training data in Amazon S3 as CSV files with 300 columns. Most Amazon Athena queries and processing jobs read only 10–15 columns and filter on a few of them. Which change best reduces the amount of data scanned?
- Option A: Convert the files to JSON Lines
- Option B: Combine all CSV files into one large file
- Option C: Convert the data to Apache Parquet
- Option D: Compress the CSV files with gzip
Show answer and explanation
Correct answer: C. Convert the data to Apache Parquet
The exam guide asks you to choose data formats such as Parquet, JSON, CSV and ORC based on access patterns. When queries touch a few columns of wide tables, a columnar format like Parquet or ORC is the standard choice.
- A (incorrect)JSON is a row-based text format. Every record still has to be read in full, and the field names repeated in each record add size.
- B (incorrect)File consolidation can reduce overhead from many small files, but a single CSV file is still row-based and is scanned in full.
- C (correct)Correct. Parquet is a columnar format with per-column compression, and block statistics allow engines such as Athena to skip data they do not need.
- D (incorrect)Compression reduces storage, but a gzip CSV file still has to be decompressed and read row by row, including the unused columns.
Reference: Amazon Athena: Use columnar storage formats (opens in a new tab)

