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.Subscribe to an RDS event subscription and configure it to use an Amazon SNS topic to send notifications.
• C.Use Amazon SES to send notifications based on configured Amazon CloudWatch Events events.
• D.Create an Amazon CloudWatch Events event to send a notification using Amazon SNS on every API call logged in AWS CloudTrail.
• E.Enable email notifications for AWS Trusted Advisor.

Comment: *

Name: *

Email: *

Verification: *

A business just transitioned from an on-premises Oracle database to Amazon Aurora PostgreSQL. Following the move, the organization observed that every day around 3:00 PM, the application's response time is substantially slower. The firm has determined that the problem is with the database, not the application.
Which set of procedures should the Database Specialist do to locate the erroneous PostgreSQL query most efficiently?

• A.Create an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and disk space consumption. Watch these dashboards during the next slow period.
• B.Launch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring tool that will run reports based on the output error logs.
• C.Modify the logging database parameter to log all the queries related to locking in the database and then check the logs after the next slow period for this information.
• D.Enable Amazon RDS Performance Insights on the PostgreSQL database. Use the metrics to identify any queries that are related to spikes in the graph during the next slow period.

Comment: *

Name: *

Email: *

Verification: *

A stock market analysis firm maintains two locations: one in the us-east-1 Region and another in the eu-west-2 Region. The business want to build an AWS database solution capable of providing rapid and accurate updates.
Dashboards with advanced analytical queries are used to present data in the eu-west-2 office. Because the corporation will use these dashboards to make purchasing choices, they must have less than a second to obtain application data.
Which solution satisfies these criteria and gives the MOST CURRENT dashboard?

• A.Deploy an Amazon RDS DB instance in us-east-1 with a read replica instance in eu-west-2. Create an Amazon ElastiCache cluster in eu-west-2 to cache data from the read replica to generate the dashboards.
• B.Use an Amazon DynamoDB global table in us-east-1 with replication into eu-west-2. Use multi-active replication to ensure that updates are quickly propagated to eu-west-2.
• C.Use an Amazon Aurora global database. Deploy the primary DB cluster in us-east-1. Deploy the secondary DB cluster in eu-west-2. Configure the dashboard application to read from the secondary cluster.
• D.Deploy an Amazon RDS for MySQL DB instance in us-east-1 with a read replica instance in eu-west-2.Configure the dashboard application to read from the read replica.

Comment: *

Name: *

Email: *

Verification: *

The Amazon CloudWatch metric for FreeLocalStorage on an Amazon Aurora MySQL DB instance shows that the amount of local storage is below 10 MB. A database engineer must increase the local storage available in the Aurora DB instance.
How should the database engineer meet this requirement?

• A.Modify the DB instance to use an instance class that provides more local SSD storage.
• B.Modify the Aurora DB cluster to enable automatic volume resizing.
• C.Increase the local storage by upgrading the database engine version.
• D.Modify the DB instance and configure the required storage volume in the configuration section.

Comment: *

Name: *

Email: *

Verification: *

A major organization maintains a number of Amazon DB clusters. Each of these clusters is configured differently to meet certain needs. These configurations may be classified into wider groups based on the team and use case.
A database administrator wishes to streamline the process of storing and updating these settings. Additionally, the database administrator want to guarantee that changes to certain configuration categories are automatically implemented to all instances as necessary.
Which AWS service or functionality will assist in automating and achieving this goal?

• A.AWS Systems Manager Parameter Store
• B.DB parameter group
• C.AWS Config
• D.AWS Secrets Manager

Comment: *

Name: *

Email: *

Verification: *