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

Markus

6 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

7 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

...