AWS Certified Database – Specialty — Question 117

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?

Answer options

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

Correct answer: D

Explanation

Option D is correct because it uses Amazon Aurora with a read replica, which improves performance and scalability for reporting applications, and utilizes a stored procedure and AWS Lambda to send messages to an SNS topic, supporting the email notification feature. Option A lacks the benefits of using a managed service like Aurora and Auto Scaling may not optimally handle reporting loads. Option B does not directly support the requirement of a stored procedure for email notifications, relying instead on event subscriptions. Option C, while using MySQL, does not provide the performance enhancements offered by Aurora and relies on a single EC2 instance with a read replica, which may not sufficiently address the performance issues.