Amazon Exam BDS-C00 Topic 6 Question 98 Discussion

Actual exam question for Amazon's BDS-C00 exam

Question #: 98
Topic #: 6

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

Sang

4 months ago

Absolutely, Option B is the winner here. Automating the process as much as possible is key, and SQS provides a nice, hands-off way to make that happen. No more relying on the human element!

upvoted 0 times

...

Kristel

4 months ago

Haha, imagine the poor person in charge of that email notification. They'll probably end up setting a calendar reminder to remember to hit 'send' every hour. Option B is definitely the way to go.

upvoted 0 times

Rosalyn

3 months ago

Yeah, using SQS to automate the process would be much more efficient.

upvoted 0 times

...

Sarina

3 months ago

Option B is definitely the way to go.

upvoted 0 times

...

Tammara

4 months ago

I see your point, Herminia. But I think option D might be the most practical solution as it combines the benefits of using a Read Replica and SQS.

upvoted 0 times

...

Cyndy

5 months ago

I agree with Lizbeth. SQS is a great way to decouple the systems and ensure the dashboard update is triggered reliably. Plus, who wants to rely on someone remembering to send an email every time?

upvoted 0 times

Kerrie

3 months ago

I totally agree, using SQS would definitely streamline the process and eliminate the need for manual email notifications.

upvoted 0 times

...

Felix

3 months ago

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

upvoted 0 times

...

Julieta

4 months ago

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

upvoted 0 times

...

Oneida

4 months ago

I agree, using SQS to automate the process is definitely the way to go.

upvoted 0 times

...

Carlton

4 months ago

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

upvoted 0 times

...

Derrick

4 months ago

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

upvoted 0 times

...

Herminia

5 months ago

I disagree, I believe option B is better as SQS can handle the message delivery more efficiently than SNS.

upvoted 0 times

...

Lizbeth

5 months ago

Option B seems the best approach here. Using SQS to send a message to the on-premises system is a more reliable and automated way to trigger the dashboard update, rather than relying on a manual email notification.

upvoted 0 times

Daniela

4 months ago

That sounds like a good solution. It would definitely help automate the process and improve performance.

upvoted 0 times

...

Noble

4 months ago

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

upvoted 0 times

...

Rocco

5 months ago

I think option A is the best choice because Redshift is optimized for analytics and SNS can easily notify the on-premises system.

upvoted 0 times

...