AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ68

Data Ingestion and Transformation

A data engineer must join data from multiple sources for a one-time analysis job. The data resides in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3.

Which solution meets this requirement in the MOST cost-effective way?

  • A Use an Amazon EMR provisioned cluster to read from all sources. Use Apache Spark to join the data and perform the analysis.
  • B Copy the data from DynamoDB, Amazon RDS, and Amazon Redshift into Amazon S3. Run Amazon Athena queries directly on the S3 files.
  • C Use Amazon Athena Federated Query to join the data from all data sources.
  • D Use Redshift Spectrum to query data from DynamoDB, Amazon RDS, and Amazon S3 directly from Redshift.
Explanation

Amazon Athena Federated Query runs SQL joins across data stored in Amazon S3 and supported relational and non-relational sources without first copying all data into a separate location. Its serverless, query-based model is well suited to a one-time analysis and avoids the ongoing cluster provisioning cost of Amazon EMR. Amazon Redshift Spectrum queries files in Amazon S3, not DynamoDB or Amazon RDS directly.

Learn more

Community Discussion

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