AWS Certified Data Engineer – Associate (DEA-C01) — Question 219

An ecommerce company processes millions of orders each day. The company uses AWS Glue ETL to collect data from multiple sources, clean the data, and store the data in an Amazon S3 bucket in CSV format by using the S3 Standard storage class. The company uses the stored data to conduct daily analysis.

The company wants to optimize costs for data storage and retrieval.

Which solution will meet this requirement?

Answer options

• A. Transition the data to Amazon S3 Glacier Flexible Retrieval.
• B. Transition the data from Amazon S3 to an Amazon Aurora cluster.
• C. Configure AWS Glue ETL to transform the incoming data to Apache Parquet format.
• D. Configure AWS Glue ETL to use Amazon EMR to process incoming data in parallel.

Correct answer: C

Explanation

The correct answer is C because transforming the data into Apache Parquet format optimizes storage efficiency and reduces costs due to its columnar storage and compression capabilities. Options A and B do not directly address storage optimization for daily analysis, while D focuses on processing rather than cost-effective storage.