DBS-C01 · Question #108
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…
The correct answer is D. Use Amazon Aurora MySQL with a read replica for the reporting applications. RDS event subscriptions do not cover "data is inserted into a table". https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_Events.Messages.ht We can use stored procedure to invoke Lambda function…
Question
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?
Options
- AUse MySQL running on an Amazon EC2 instance with Auto Scaling to accommodate the
- BUse Amazon Aurora MySQL in a multi-master cluster to accommodate the reporting applications.
- CUse MySQL running on an Amazon EC2 instance with a read replica to accommodate the
- DUse Amazon Aurora MySQL with a read replica for the reporting applications.
How the community answered
(28 responses)- A14% (4)
- B4% (1)
- C7% (2)
- D75% (21)
Explanation
RDS event subscriptions do not cover "data is inserted into a table". https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_Events.Messages.ht We can use stored procedure to invoke Lambda function. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.La
Topics
Community Discussion
No community discussion yet for this question.