Free DATA-ENGINEER-ASSOCIATE Web TestEngine Demo

Q8 Single choice

An ecommerce company collects daily customer transaction logs in CSV format and stores the logs in Amazon S3. The company uses Amazon Athena to scan a subset of attributes from the logs on the same day the company receives each log.

Query times are increasing because of increasing transaction volume. The company wants to improve query performance.

Which solution will meet these requirements with the SHORTEST query times?

A
Convert the CSV logs into multiple ORC files for better parallelism in Athena. Partition by date in Amazon S3. Use columnar pushdown filters.
B
Convert the CSV logs to JSON. Partition by date in Amazon S3. Use Athena with dynamic filtering to reduce data scans.
C
Convert the CSV logs to Avro. Partition by date in Amazon S3. Use Athena with projection-based partitioning.
D
Convert the CSV logs to a single Apache Parquet file for each day Partition the data by date in Amazon
S3. Use Athena with predicate pushdown filters.

DATA-ENGINEER-ASSOCIATE Web TestEngine demo