Amazon Exam BDS-C00 Topic 9 Question 96 Discussion

Actual exam question for Amazon's BDS-C00 exam

Question #: 96
Topic #: 9

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?

AReplace RDS with Redshift for the batch analysis and SNS to notify the on-premises system to update the dashboard

BReplace RDS with Redshift for the batch analysis and SQS to send a message to the on-premises system to update the dashboard

CCreate an RDS Read Replica for the batch analysis and SNS to notify me on-premises system to update the dashboard

DCreate an RDS Read Replica for the batch analysis and SQS to send a message to the on-premises system to update the dashboard.

Show Suggested Answer

Suggested Answer: C

by Pansy at Jul 03, 2024, 02:51 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Sophia

1 months ago

I think both options have their merits. It ultimately depends on the specific requirements and constraints of the company. But I lean towards option D for its scalability and efficiency.

upvoted 0 times

...

Carlee

1 months ago

If I had a nickel for every time I had to integrate with a 'managed by another team' system, I'd be a rich person. Option B seems like the way to go, but I hope the on-premises team has a good sense of humor.

upvoted 0 times

...

Brittni

1 months ago

Ah, the joys of dealing with legacy systems. Option C with the RDS Read Replica might be the most straightforward approach here. At least it doesn't involve introducing a whole new database platform.

upvoted 0 times

Heike

26 days ago

Yeah, I agree. It's probably the least disruptive option for the on-premises system.

upvoted 0 times

...

Isabella

27 days ago

Option C with the RDS Read Replica sounds like a good idea. It keeps things simple.

upvoted 0 times

...

Myra

1 months ago

That's a good point, Brendan. Using a Read Replica can definitely improve performance. But wouldn't SNS be more reliable for notifications?

upvoted 0 times

...

2 months ago

Option B sounds the most promising. Using SQS to send a message to the on-premises system seems like a more reliable and scalable way to automate the update process.

upvoted 0 times

Goldie

23 days ago

I agree, SQS would definitely help streamline the process and reduce the manual effort required for updating the dashboard.

upvoted 0 times

...

Dong

1 months ago

Option B sounds the most promising. Using SQS to send a message to the on-premises system seems like a more reliable and scalable way to automate the update process.

upvoted 0 times

...