AmazonAmazon
DEA-C01 · Question #83
DEA-C01 Question #83: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #83. The question stem and answer options stay visible for context.
Data Ingestion and Transformation
Question
A data engineer needs Amazon Athena queries to finish faster. The data engineer notices that all the files the Athena queries use are currently stored in uncompressed .csv format. The data engineer also notices that users perform most queries by selecting a specific column. Which solution will MOST speed up the Athena query performance?
Options
- AChange the data format from .csv to JSON format. Apply Snappy compression.
- BCompress the .csv files by using Snappy compression.
- CChange the data format from .csv to Apache Parquet. Apply Snappy compression.
- DCompress the .csv files by using gzip compression.
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Athena#Data Formats#Columnar Storage#Performance Optimization