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

Ocie

2 months ago

I wonder if the customer has considered using a crystal ball to query the data. It's probably more reliable than some of these fancy-schmancy data solutions.

upvoted 0 times

Maybelle

9 days ago

C: D) 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.

upvoted 0 times

...

Evangelina

12 days ago

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

upvoted 0 times

...

Yesenia

18 days ago

A: A) Load all data from a different database/warehouse to S3. Use Redshift COPY command to copy data to Redshift for analysis.

upvoted 0 times

...

Howard

2 months ago

I like the simplicity of option A. Just load everything to S3 and use Redshift to analyze it all. Sure, it might require a bit more data movement, but it's a tried-and-true approach. Plus, I bet I could write a script to automate the whole process and save the customer some time.

upvoted 0 times

Doyle

21 days ago

Definitely, option A seems like the most cost-effective solution for analyzing data from different sources.

upvoted 0 times

...

Paul

1 months ago

I agree, simplicity is key. Plus, automating the process with a script would definitely save time for the customer.

upvoted 0 times

...

Lashunda

1 months ago

Option A sounds like a solid plan. It's a straightforward process to load data to S3 and analyze it with Redshift.

upvoted 0 times

...

Isadora

2 months 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

Alida

2 months ago

D) 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.

upvoted 0 times

...

Shawnna

2 months ago

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

upvoted 0 times

...

King

2 months ago

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

upvoted 0 times

...

Kristel

2 months ago

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

upvoted 0 times

...

Cherry

2 months 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

Tiera

2 months ago

I agree, having a dedicated program to query and aggregate data from different systems could be beneficial in the long run.

upvoted 0 times

...

Hyman

2 months ago

Option D sounds like a good choice. Writing our own program could give us more control over the process.

upvoted 0 times

...

Sommer

3 months 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

3 months 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

3 months 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

3 months 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

...