nerdexam
AmazonAmazon

DEA-C01 · Question #92

DEA-C01 Question #92: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #92. The question stem and answer options stay visible for context.

Data Ingestion and Transformation

Question

A company stores 10 to 15 TB 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 file format and compression solution will meet these requirements for Athena queries?

Options

  • A.csv format compressed with zip
  • BJSON format compressed with bzip2
  • CApache Parquet format compressed with Snappy
  • DApache Avro format compressed with LZO

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

#Amazon Athena#Data Lake Formats#Columnar Storage#Compression Strategies
Full DEA-C01 PracticeBrowse All DEA-C01 Questions