An online shopping company has a large inflow of shopping requests daily. As a result, there is a consistent load on the company's Amazon RDS database. A database specialist needs to ensure the database is up and running at all times. The database specialist wants an automatic notification system for issues that may cause database downtime or for configuration changes made to the database.
What should the database specialist do to achieve this? (Choose two.)

• A.Configure Amazon CloudWatch alarms on various metrics, such as FreeStorageSpace for the RDS instance.
• B.Enable email notifications for AWS Trusted Advisor.
• C.Create an Amazon CloudWatch Events event to send a notification using Amazon SNS on every API call logged in AWS CloudTrail.
• D.Use Amazon SES to send notifications based on configured Amazon CloudWatch Events events.
• E.Subscribe to an RDS event subscription and configure it to use an Amazon SNS topic to send notifications.

Comment: *

Name: *

Email: *

Verification: *

A company developed a new application that is deployed on Amazon EC2 instances behind an Application Load Balancer. The EC2 instances use the security group named sg-application-servers. The company needs a database to store the data from the application and decides to use an Amazon RDS for MySQL DB instance.
The DB instance is deployed in private DB subnet.
What is the MOST restrictive configuration for the DB instance security group?

• A.Only allow incoming traffic from the sg-application-servers security group on port 3306.
• B.Only allow incoming traffic from the sg-application-servers security group on port 443.
• C.Only allow incoming traffic from the subnet of the application servers on port 3306.
• D.Only allow incoming traffic from the subnet of the application servers on port 443.

Comment: *

Name: *

Email: *

Verification: *

A company is using Amazon Aurora PostgreSQL for the backend of its application. The system users are complaining that the responses are slow. A database specialist has determined that the queries to Aurora take longer during peak times. With the Amazon RDS Performance Insights dashboard, the load in the chart for average active sessions is often above the line that denotes maximum CPU usage and the wait state shows that most wait events are IO:XactSync.
What should the company do to resolve these performance issues?

• A.Add an Aurora Replica to scale the read traffic.
• B.Scale up the DB instance class.
• C.Modify applications to commit transactions in batches.
• D.Modify applications to avoid conflicts by taking locks.

Comment: *

Name: *

Email: *

Verification: *

A company is closing one of its remote data centers. This site runs a 100 TB on-premises data warehouse solution. The company plans to use the AWS Schema Conversion Tool (AWS SCT) and AWS DMS for the migration to AWS. The site network bandwidth is 500 Mbps. A Database Specialist wants to migrate the on-premises data using Amazon S3 as the data lake and Amazon Redshift as the data warehouse. This move must take place during a 2-week period when source systems are shut down for maintenance. The data should stay encrypted at rest and in transit.
Which approach has the least risk and the highest likelihood of a successful data transfer?

• A.Leverage AWS SCT and apply the converted schema to Amazon Redshift. Start an AWS DMS task withtwo AWS Snowball Edge devices to copy data from on-premises to Amazon S3 with AWS KMS encryption.Use AWS DMS to finish copying data to Amazon Redshift.
• B.Leverage AWS SCT and apply the converted schema to Amazon Redshift. Once complete, use a fleet of10 TB dedicated encrypted drives using the AWS Import/Export feature to copy data from on-premises toAmazon S3 with AWS KMS encryption. Use AWS Glue to load the data to Amazon redshift.
• C.Set up a VPN tunnel for encrypting data over the network from the data center to AWS. Leverage AWSSCT and apply the converted schema to Amazon Redshift. Once complete, start an AWS DMS task tomove the data from the source to Amazon S3. Use AWS Glue to load the data from Amazon S3 to AmazonRedshift.
• D.Set up a VPN tunnel for encrypting data over the network from the data center to AWS. Leverage a nativedatabase export feature to export the data and compress the files. Use the aws S3 cp multi-port uploadcommand to upload these files to Amazon S3 with AWS KMS encryption. Once complete, load the data toAmazon Redshift using AWS Glue.

Comment: *

Name: *

Email: *

Verification: *

A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for MySQL DB instance. Immediately after creating the read replica, users that query it report slow response times.
What could be causing these slow response times?

• A.New volumes created from snapshots load lazily in the background
• B.Long-running statements on the master
• C.Insufficient resources on the master
• D.Overload of a single replication thread by excessive writes on the master

Comment: *

Name: *

Email: *

Verification: *