A data engineer needs to optimize the performance aws video
data-engineer video for a data engineer needs to optimize the performance and cost of SQL queries run in Amazon Athena on large datasets stored in Amazon S3.
Answer
Full Certification Question
A data engineer needs to optimize the performance and cost of SQL queries run in Amazon Athena on large datasets stored in Amazon S3. The engineer is exploring partitioning and data formats to minimize the amount of data scanned. Which combination of strategies will BEST optimize query performance and cost? (Choose TWO.)