AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ120

Data Operations and Support

A company keeps a large dataset in an Amazon S3 bucket. A data engineer often runs complex queries against the dataset using Amazon Athena. The data engineer must optimize query performance and reduce costs for queries run multiple times with identical parameters.

Which solution meets these requirements?

  • A Convert the dataset to JSON format before running Athena queries.
  • B Use Amazon EMR to pre-process the data before running Athena queries.
  • C Configure query result reuse settings in the Athena workgroup.
  • D Use Amazon Redshift Spectrum to query the data in Amazon S3.
Explanation

Athena query result reuse can return a previous matching query result from the same workgroup instead of executing the query again. Reusing the stored result improves performance and reduces costs by avoiding additional data scanning.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!