A data engineer needs to optimize the performance of a data pipeline that handles retail...

Vendor: Amazon Web Services
Product: Data-Engineer-Associate
Update on: Mar 14, 2026
Questions: 289

Amazon Web Services Data-Engineer-Associate Question Answer

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 on 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.

Partition the data based on order date. Use Amazon Athena to query the data.

Partition the data based on order date. Use Amazon Redshift to query the data.

Partition the data based on load date. Use Amazon EMR to query the data.

Partition the data based on load date. Use Amazon Aurora to query the data.