Amazon Exam BDS-C00 Topic 6 Question 98 Discussion

Actual exam question for Amazon's BDS-C00 exam

Question #: 98
Topic #: 6

A social media customer has data from different data sources including RDS running MySQL, RedShift, and Hive on EMR. To support better analysis, the customer needs to be able to analyze data from different data sources and to combine the results.

What is the most cost-effective solution to meet these requirements?

ALoad all data from a different database/warehouse to S3. Use Redshift COPY command to copy data to Redshift for analysis.

BInstall Presto on the EMR cluster where Hive sits. Configure MySQL and PostgreSQL connector to select from different data sources in a single query.

CSpin up an Elasticsearch cluster. Load data from all three data sources and use Kibana to analyze.

DWrite a program running on a separate EC2 instance to run queries to three different systems. Aggregate the results after getting the responses from all three systems.

Show Suggested Answer

Suggested Answer: C

by Virgina at Jul 16, 2024, 06:42 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Isadora

4 days ago

Ooh, option C sounds interesting! Elasticsearch and Kibana could give us some really slick data visualization capabilities. But I'm not sure if it's the most cost-effective solution, especially with the need to set up a whole new cluster.

upvoted 0 times

...

Cherry

10 days ago

I'm leaning towards option D. Sure, it might require a bit more work, but having a dedicated program to query the different systems and aggregate the results could give us more control and flexibility. Plus, it's always fun to write your own code, am I right?

upvoted 0 times

...

Sommer

11 days ago

Hmm, I think option B is the way to go. Presto can query across different data sources without the need for data movement. Plus, it's probably the most cost-effective solution since we don't have to spin up any additional resources like EC2 or Elasticsearch.

upvoted 0 times

...

Huey

12 days ago

I personally think option C could be a good solution. Setting up an Elasticsearch cluster and using Kibana for analysis might provide a more flexible approach.

upvoted 0 times

...

Markus

26 days ago

I disagree, I believe option A is more cost-effective. Loading data to S3 and using Redshift COPY command for analysis seems simpler and efficient.

upvoted 0 times

...

Ivette

27 days ago

I think option B is the best solution. Installing Presto on the EMR cluster seems like a cost-effective way to analyze data from different sources.

upvoted 0 times

...