Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Amazon BDS-C00 Exam - Topic 2 Question 118 Discussion

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?
A) Presto
B) MicroStrategy
C) Pig
D) R Studio

Amazon BDS-C00 Exam - Topic 2 Question 118 Discussion

Actual exam question for Amazon's BDS-C00 exam
Question #: 118
Topic #: 2
[All BDS-C00 Questions]

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Pedro
6 months ago
Definitely leaning towards Presto here!
upvoted 0 times
...
Beatriz
6 months ago
Pig is too slow for interactive joins, right?
upvoted 0 times
...
Maryrose
6 months ago
I think MicroStrategy is overkill for this.
upvoted 0 times
...
Kaycee
6 months ago
Wait, R Studio for this? That seems odd!
upvoted 0 times
...
Maybelle
6 months ago
Presto is great for querying S3 data!
upvoted 0 times
...
Zona
7 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
7 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
7 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
7 months ago
I remember that Presto is designed for interactive queries, which seems like a good fit for this scenario.
upvoted 0 times
...
Jarvis
7 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
8 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
8 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
8 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
10 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
Kaitlyn
10 months ago
C) Pig might work too, but Presto is more suitable for interactive joins.
upvoted 0 times
...
Linwood
10 months ago
A) Presto is definitely the best choice for this scenario.
upvoted 0 times
...
...
Belen
10 months ago
That makes sense, we need a technology that can handle interactive joins quickly.
upvoted 0 times
...
Emilio
11 months ago
Pig is more suitable for ETL tasks, while Presto is better for interactive queries.
upvoted 0 times
...
Elli
11 months ago
I'm not sure, but I think Pig could also be a good option for this scenario.
upvoted 0 times
...
Dalene
11 months ago
A) Presto seems like the obvious choice here. It's designed for interactive querying of large datasets, which is exactly what the customer needs.
upvoted 0 times
Annamae
10 months ago
User 3: Yeah, Presto would definitely help with performing interactive joins quickly.
upvoted 0 times
...
Danilo
10 months ago
User 2: I agree, Presto is great for interactive querying of large datasets.
upvoted 0 times
...
Novella
11 months ago
User 1: I think Presto is the best option for this scenario.
upvoted 0 times
...
...
Belen
11 months ago
I agree with Emilio, Presto is designed for interactive queries on large data sets.
upvoted 0 times
...
Emilio
11 months ago
I think the most appropriate technology for this is Presto.
upvoted 0 times
...

Save Cancel