AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 211

Question

A data engineer needs to optimize the performance of a data pipeline that handles retail orders. Data about the orders is ingested daily into an Amazon S3 bucket. The data engineer runs queries once each week to extract metrics from the orders data based the order date for multiple date ranges. The data engineer needs an optimization solution that ensures the query performance will not degrade when the volume of data increases. Which solution will meet this requirement MOST cost-effectively?

Accepted Answer

Correct answer: A. The correct answer is A. Option A: Partition the data based on order date. Use Amazon Athena to query the data. Amazon Athena runs serverless SQL queries directly on data in Amazon S3 with no infrastructure to manage. This option delivers the requirement at the lowest cost.

AWS Certified Data Engineer - Associate DEA-C01 — Question 211