Amazon BDS-C00 Exam - Topic 2 Question 118 Discussion

Actual exam question for Amazon's BDS-C00 exam

Question #: 118
Topic #: 2

An Amazon EMR cluster using EMRFS has access to Megabytes of data on Amazon S3, originating from multiple unique data sources. The customer needs to query common fields across some of the data sets to be able to perform interactive joins and then display results quickly.

Which technology is most appropriate to enable this capability?

APresto

BMicroStrategy

CPig

DR Studio

Show Suggested Answer

Suggested Answer: A

https://dzone.com/articles/getting-introduced-with-presto

by Georgeanna at Jul 05, 2025, 10:07 PM

Limited Time Offer

25%

Off

Get Premium BDS-C00 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Pedro

7 months ago

Definitely leaning towards Presto here!

upvoted 0 times

...

Beatriz

7 months ago

Pig is too slow for interactive joins, right?

upvoted 0 times

...

Maryrose

8 months ago

I think MicroStrategy is overkill for this.

upvoted 0 times

...

Kaycee

8 months ago

Wait, R Studio for this? That seems odd!

upvoted 0 times

...

Maybelle

8 months ago

Presto is great for querying S3 data!

upvoted 0 times

...

Zona

8 months ago

I have a vague recollection that Pig is more suited for batch processing, so it might not be the best option for quick joins.

upvoted 0 times

...

Jesusa

8 months ago

I practiced a similar question where Presto was mentioned as a fast query engine for big data. I think it might be the right choice here.

upvoted 0 times

...

Val

9 months ago

I'm not entirely sure, but I think MicroStrategy is more for business intelligence rather than querying data directly from S3.

upvoted 0 times

...

Sharee

9 months ago

I remember that Presto is designed for interactive queries, which seems like a good fit for this scenario.

upvoted 0 times

...

Jarvis

9 months ago

I'm a little confused by the options here. MicroStrategy and RStudio don't seem like they'd be the best fit for this particular use case. I'm leaning towards Presto, but I want to double-check the other choices just to be sure.

upvoted 0 times

...

Veronika

9 months ago

Okay, I've got a strategy for this. Since the data is stored in S3 and the customer needs to perform interactive queries, Presto seems like the logical choice. It's optimized for that kind of workload. I'm pretty confident that's the right answer.

upvoted 0 times

...

Aleta

9 months ago

Hmm, I'm a bit unsure about this one. The question mentions "interactive joins" and "quick results", so I'm wondering if Presto might be the best fit. But I'm also curious about Pig - could that work for this use case?

upvoted 0 times

...

Lonna

10 months ago

This looks like a straightforward question about data processing and querying on Amazon EMR. I think Presto is the most appropriate choice here since it's designed for interactive SQL queries on large datasets stored in S3.

upvoted 0 times

...

Ruth

12 months ago

I'd have to go with A) Presto as well. It's specifically built for this kind of use case, and the ability to perform interactive joins is a key feature.

upvoted 0 times