Which AWS service should the Data Scientist use?

A company has raw user and transaction data stored in AmazonS3 a MySQL database, and Amazon RedShift A Data Scientist needs to perform an analysis by joining the three datasets from Amazon S3, MySQL, and Amazon RedShift, and then calculating the average-of a few selected columns from the joined data

Which AWS service should the Data Scientist use?
A . Amazon Athena
B . Amazon Redshift Spectrum
C . AWS Glue
D . Amazon QuickSight

View Answer

Answer: A

Explanation:

Amazon Athena is a serverless interactive query service that can analyze data in Amazon S3 using standard SQL. Amazon Athena can also query data from other sources, such as MySQL and Amazon Redshift, by using federated queries. Federated queries allow Amazon Athena to run SQL queries across data sources, such as relational and non-relational databases, data warehouses, and data lakes. By using Amazon Athena, the Data Scientist can perform an analysis by joining the three datasets from Amazon S3, MySQL, and Amazon Redshift, and then calculating the average of a few selected columns from the joined data. Amazon Athena can also integrate with other AWS services, such as AWS Glue and Amazon QuickSight, to provide additional features, such as data cataloging and visualization.

Reference:

What is Amazon Athena? – Amazon Athena

Federated Query Overview – Amazon Athena

Querying Data from Amazon S3 – Amazon Athena

Querying Data from MySQL – Amazon Athena

[Querying Data from Amazon Redshift – Amazon Athena]