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

Comment: *

Name: *

Email: *

Verification: *

The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago. A Database Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for the Security team to use for monitoring and alerting. The Security team is required to perform real- time alerting and monitoring outside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution.
Which approach will meet these requirements?

• A.Use pg_audit to generate audit logs and send the logs to the Security team.
• B.Use AWS CloudTrail to audit the DB cluster and the Security team will get data from Amazon S3.
• C.Set up database activity streams and connect the data stream from Amazon Kinesis to consumer applications.
• D.Turn on verbose logging and set up a schedule for the logs to be dumped out for the Security team.

Comment: *

Name: *

Email: *

Verification: *

A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL DB instance and is reviewing related metrics. The team wants to narrow the possibilities down to specific database wait events to better understand the situation.
How can the Database Specialists accomplish this?

• A.Enable the option to push all database logs to Amazon CloudWatch for advanced analysis
• B.Create appropriate Amazon CloudWatch dashboards to contain specific periods of time
• C.Enable Amazon RDS Performance Insights and review the appropriate dashboard
• D.Enable Enhanced Monitoring will the appropriate settings

Comment: *

Name: *

Email: *

Verification: *

A company has deployed an e-commerce web application in a new AWS account. An Amazon RDS for MySQL Multi-AZ DB instance is part of this deployment with a database-1.xxxxxxxxxxxx.us-east-
1.rds.amazonaws.com endpoint listening on port 3306. The company's Database Specialist is able to log in to MySQL and run queries from the bastion host using these details.
When users try to utilize the application hosted in the AWS account, they are presented with a generic error message. The application servers are logging a "could not connect to server: Connection times out" error message to Amazon CloudWatch Logs.
What is the cause of this error?

• A.The security group assigned to the DB instance does not have the necessary rules to allow inbound connections from the application servers.
• B.The security group assigned to the application servers does not have the necessary rules to allow inbound connections from the DB instance.
• C.The user name and password are correct, but the user is not authorized to use the DB instance.
• D.The user name and password the application is using are incorrect.

Comment: *

Name: *

Email: *

Verification: *

A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS-specified maintenance window.
What is the MOST cost-effective action that should be taken to avoid downtime?

• A.Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
• B.Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down
• C.Enable a read replicas and direct read traffic to it when Amazon RDS is down
• D.Enable an Amazon RDS for MySQL Multi-AZ configuration

Comment: *

Name: *

Email: *

Verification: *