Amazon MLS-C01 Exam - Topic 1 Question 40 Discussion

Actual exam question for Amazon's MLS-C01 exam

Question #: 40
Topic #: 1

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?

AAmazon Athena

BAmazon Redshift Spectrum

CAWS Glue

DAmazon QuickSight

Show Suggested Answer

Suggested Answer: A

by Bernardine at May 05, 2022, 05:47 AM

Limited Time Offer

25%

Off

Get Premium MLS-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Charolette

4 months ago

QuickSight is more for visualization, not for joining datasets.

upvoted 0 times

...

Phillip

4 months ago

Wait, can you really join data from all three sources like that? Sounds tricky!

upvoted 0 times

...

Adrianna

4 months ago

AWS Glue could help with data transformation before analysis.

upvoted 0 times

...

Huey

4 months ago

I disagree, Amazon Athena seems more straightforward for querying S3 data.

upvoted 0 times

...

Theodora

5 months ago

I think Amazon Redshift Spectrum is the way to go for this.

upvoted 0 times

...

Ozell

5 months ago

Okay, let me see here. REST is definitely interoperable, so D is true. And I think it's also reliable, so C is true as well. The other options seem a bit iffy to me.

upvoted 0 times

...

Jonelle

5 months ago

I think the Salesforce CLI is the correct answer, but I'm not 100% certain. I'll double-check my notes just to be sure.

upvoted 0 times

...