ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 106 - MLS-C01 discussion

Report
Export

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
Answers
A.
Amazon Athena
B.
Amazon Redshift Spectrum
Answers
B.
Amazon Redshift Spectrum
C.
AWS Glue
Answers
C.
AWS Glue
D.
Amazon QuickSight
Answers
D.
Amazon QuickSight
Suggested 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.

References:

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]

asked 16/09/2024
Ramon Vieira da Rocha
37 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first