Explanation:
Amazon Athena Federated Query allows you to query data across relational, non-relational, object, and custom data sources. With Athena Federated Query, customers can submit a single SQL query that scans data from sources like Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3 without needing to move the data, which is highly cost-effective for a one-time analysis job.
Ultimate access to all questions.
A data engineer needs to join data from multiple sources to perform a one-time analysis job. The data is stored in Amazon DynamoDB, Amazon RDS, Amazon Redshift, and Amazon S3. Which solution will meet this requirement MOST cost-effectively?
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.
No comments yet.