BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Amazon Exam BDS-C00 Topic 12 Question 85 Discussion

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

A company is running a batch analysis every hour on their main transactional DB running on an RDS MySQL instance to populate their central Data Warehouse running on Redshift. During the execution of the batch their transactional applications are very slow. When the batch completes they need to update the top management dashboard with the new data. The dashboard is produced by another system running on-premises that is currently started when a manually-sent email notifies that an update is required The on-premises system cannot be modified because is managed by another team. How would you optimize this scenario to solve performance issues and automate the process as much as possible?

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

Alana
7 months ago
Salena, you and your donuts! But seriously, that's a good point. We should try to find a way to make it as easy as possible for the on-premises team to integrate with our solution.
upvoted 0 times
...
Salena
7 months ago
Haha, yeah, the on-premises team might be a tough nut to crack. We might need to pull some diplomatic strings to get them on board. Maybe bribe them with donuts or something?
upvoted 0 times
...
Ronny
7 months ago
Ooh, that's a clever idea, Nobuko! Using a webhook or API call would make it more flexible and easier to integrate, regardless of the on-premises system's setup.
upvoted 0 times
Johnna
6 months ago
A) Agreed, Yuki! It's all about finding the best solutions to solve performance issues.
upvoted 0 times
...
Suzan
7 months ago
B) Exactly, Akari! It's about optimizing and automating to make the workflow more efficient.
upvoted 0 times
...
Jesusita
7 months ago
A) That's right, Takeshi! It will definitely improve performance and streamline the data update process.
upvoted 0 times
...
Markus
7 months ago
B) Yes, and it can automate the process, eliminating the need for manual email notifications.
upvoted 0 times
...
Hoa
7 months ago
A) Absolutely, Midori! And using SNS will provide a reliable way to trigger updates.
upvoted 0 times
...
Tresa
7 months ago
B) That sounds like a good solution, Hiroshi! Redshift can handle large volumes of data efficiently.
upvoted 0 times
...
Diane
7 months ago
A) Replace RDS with Redshift for the batch analysis and SNS to notify the on-premises system to update the dashboard
upvoted 0 times
...
...
Nobuko
7 months ago
Good point, Priya. That could be a potential roadblock. Maybe we can suggest a more generic solution, like using a webhook or an API call to trigger the dashboard update, instead of relying on the on-premises team.
upvoted 0 times
...

Save Cancel