Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 98 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 98
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company runs a customer relationship management (CRM) system that is hosted on-premises with a MySQL database as the backend. A custom stored procedure is used to send email notifications to another system when data is inserted into a table. The company has noticed that the performance of the CRM system has decreased due to database reporting applications used by various teams. The company requires an AWS solution that would reduce maintenance, improve performance, and accommodate the email notification feature.
Which AWS solution meets these requirements?

A. Use MySQL running on an Amazon EC2 instance with Auto Scaling to accommodate the reporting applications. Configure a stored procedure and an AWS Lambda function that uses Amazon SES to send email notifications to the other system.
B. Use Amazon Aurora MySQL in a multi-master cluster to accommodate the reporting applications. Configure Amazon RDS event subscriptions to publish a message to an Amazon SNS topic and subscribe the other system's email address to the topic.
C. Use MySQL running on an Amazon EC2 instance with a read replica to accommodate the reporting applications. Configure Amazon SES integration to send email notifications to the other system.
D. Use Amazon Aurora MySQL with a read replica for the reporting applications. Configure a stored procedure and an AWS Lambda function to publish a message to an Amazon SNS topic. Subscribe the other system's email address to the topic.

Show Suggested Answer

Suggested Answer: D 🗳️

by shantest1 at April 5, 2021, 2:42 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

shantest1

Highly Voted 3 years, 8 months ago

D. Answer Reduce maintenance, hosting database on EC2 increases maintenance.

upvoted 8 times

manan728

3 years, 8 months ago

Did you take the real test @shantest1? Are the questions here valid if you know by any chance.

upvoted 1 times

...

Pranava_GCP

Most Recent 1 year, 9 months ago

Selected Answer: D

D. Use Amazon Aurora MySQL with a read replica for the reporting applications. Configure a stored procedure and an AWS Lambda function to publish a message to an Amazon SNS topic. Subscribe the other system's email address to the topic.

upvoted 2 times

Pranava_GCP

1 year, 9 months ago

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.Lambda.html

upvoted 1 times

...

novice_expert

3 years, 1 month ago

Selected Answer: D

reporting => read replica

upvoted 2 times

...

RotterDam

3 years, 3 months ago

Got this question in my exam. (i cleared it). D is correct

upvoted 2 times

...

GMartinelli

3 years, 5 months ago

Selected Answer: D

Option D

upvoted 1 times

...

guru_ji

3 years, 7 months ago

Correct Answer: D

upvoted 1 times

...

Suresh108

3 years, 7 months ago

DDDDDDDDD is my choice

upvoted 1 times

...

Aesthet

3 years, 7 months ago

D final answer

upvoted 2 times

...

Zhongkai

3 years, 8 months ago

RDS event subscriptions do not cover "data is inserted into a table" - see https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_Events.Messages.html We can use stored procedure to invoke Lambda function - https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.Lambda.html So I will go with B

upvoted 2 times

Zhongkai

3 years, 8 months ago

Typo. I mean D

upvoted 1 times

...