AWS Certified Big Data - Specialty (#69)

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?

Load all data from a different database/warehouse to S3. Use Redshift COPY command to copy data to Redshift for analysis.
Install Presto on the EMR cluster where Hive sits. Configure MySQL and PostgreSQL connector to select from different data sources in a single query.
Spin up an Elasticsearch cluster. Load data from all three data sources and use Kibana to analyze.
Write 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.