DEA-C01 · Question #221
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 e
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #221. The question stem and answer options stay visible for context.
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?
Options
- APartition the data based on order date. Use Amazon Athena to query the data.
- BPartition the data based on order date. Use Amazon Redshift to query the data.
- CPartition the data based on load date. Use Amazon EMR to query the data.
- DPartition the data based on load date. Use Amazon Aurora to query the data.
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.