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?

1. A. Use MySQL running on an Amazon EC2 instance with Auto Scaling to accommodate the reporting application
2. B. Configure a stored procedure and an AWS Lambda function that uses Amazon SES to send email notifications to the other system.
3. C. 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.
4. D. Use MySQL running on an Amazon EC2 instance with a read replica to accommodate the reporting application
5. E. Configure Amazon SES integration to send email notifications to the other system.
6. F. Use Amazon Aurora MySQL with a read replica for the reporting application
7. G. Configure a stored procedure and an AWS Lambda function to publish a message to an Amazon SNS topi
8. H. Subscribe the other system's email address to the topic.

Correct Answer: D
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

A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The database specialist needs to ensure that the DB instance storage grows as needed.
What is the MOST operationally efficient and cost-effective solution?

1. A. Configure RDS Storage Auto Scaling.
2. B. Configure RDS instance Auto Scaling.
3. C. Modify the DB instance allocated storage to meet the forecasted requirements.
4. D. Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.

Correct Answer: A
If your workload is unpredictable, you can enable storage autoscaling for an Amazon RDS DB instance. With storage autoscaling enabled, when Amazon RDS detects that you are running out of free database space it automatically scales up your storage.
https://aws.amazon.com/about-aws/whats-new/2019/06/rds-storage-auto-scaling/
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIOPS.StorageTypes.html#USER_PIOPS.

A company is using a Single-AZ Amazon RDS for MySQL DB instance for development. The DB instance is experiencing slow performance when queries are executed. Amazon CloudWatch metrics indicate that the instance requires more I/O capacity.
Which actions can a database specialist perform to resolve this issue? (Choose two.)

1. A. Restart the application tool used to execute queries.
2. B. Change to a database instance class with higher throughput.
3. C. Convert from Single-AZ to Multi-AZ.
4. D. Increase the I/O parameter in Amazon RDS Enhanced Monitoring.
5. E. Convert from General Purpose to Provisioned IOPS (PIOPS).

Correct Answer: BE
https://aws.amazon.com/blogs/database/best-storage-practices-for-running-production-workloads-on-hosted-data
"If you find the pattern of IOPS usage consistently going beyond more than 16,000, you should modify the DB instance and change the storage type from gp2 to io1.

A company has an on-premises system that tracks various database operations that occur over the lifetime of a database, including database shutdown, deletion, creation, and backup.
The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy these requirements. The data could be used by other systems within the company.
Which solution will meet these requirements with minimal effort?

1. A. Create an Amazon Cloudwatch Events rule with the operations that need to be tracked on Amazon RD
2. B. Create an AWS Lambda function to act on these rules and write the output to the tracking systems.
3. C. Create an AWS Lambda function to trigger on AWS CloudTrail API call
4. D. Filter on specific RDS API calls and write the output to the tracking systems.
5. E. Create RDS event subscription
6. F. Have the tracking systems subscribe to specific RDS event systemnotifications.
7. G. Write RDS logs to Amazon Kinesis Data Firehos
8. H. Create an AWS Lambda function to act on these rules and write the output to the tracking systems.

Correct Answer: C

A Database Specialist is constructing a new Amazon Neptune DB cluster and tries to load data from Amazon S3 using the Neptune bulk loader API. The Database Specialist is confronted with the following error message:
€Unable to establish a connection to the s3 endpoint. The source URL is s3:/mybucket/graphdata/ and the region code is us-east-1. Kindly confirm your Configuration S3.
Which of the following activities should the Database Specialist take to resolve the issue? (Select two.)

1. A. Check that Amazon S3 has an IAM role granting read access to Neptune
2. B. Check that an Amazon S3 VPC endpoint exists
3. C. Check that a Neptune VPC endpoint exists
4. D. Check that Amazon EC2 has an IAM role granting read access to Amazon S3
5. E. Check that Neptune has an IAM role granting read access to Amazon S3

Correct Answer: BE
https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-tutorial-IAM.html https://docs.aws.amazon.com/neptune/latest/userguide/bulk-load-data.html
“An IAM role for the Neptune DB instance to assume that has an IAM policy that allows access to the data files in the S3 bucket. The policy must grant Read and List permissions.” “An Amazon S3 VPC endpoint. For more information, see the Creating an Amazon S3 VPC Endpoint section.”