QuestionQ68

VerifiedData 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?

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!