A company is load testing its three-tier production web application deployed with an AWS CloudFormation template on AWS. The Application team is making changes to deploy additional Amazon EC2 and AWS Lambda resources to expand the load testing capacity. A Database Specialist wants to ensure that the changes made by the Application team will not change the Amazon RDS database resources already deployed.
Which combination of steps would allow the Database Specialist to accomplish this? (Choose two.)

• A.Review the stack drift before modifying the template
• B.Create and review a change set before applying it
• C.Export the database resources as stack outputs
• D.Define the database resources in a nested stack
• E.Set a stack policy for the database resources

Comment: *

Name: *

Email: *

Verification: *

A company is running a two-tier ecommerce application in one AWS account. The web server is deployed using an Amazon RDS for MySQL Multi-AZ DB instance. A Developer mistakenly deleted the database in the production environment. The database has been restored, but this resulted in hours of downtime and lost revenue.
Which combination of changes in existing IAM policies should a Database Specialist make to prevent an error like this from happening in the future? (Choose three.)

• A.Grant least privilege to groups, users, and roles
• B.Allow all users to restore a database from a backup that will reduce the overall downtime to restore the database
• C.Enable multi-factor authentication for sensitive operations to access sensitive resources and API operations
• D.Use policy conditions to restrict access to selective IP addresses
• E.Use AccessList Controls policy type to restrict users for database instance deletion
• F.Enable AWS CloudTrail logging and Enhanced Monitoring

Comment: *

Name: *

Email: *

Verification: *

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

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

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 is running a website on Amazon EC2 instances deployed in multiple Availability Zones (AZs). The site performs a high number of repetitive reads and writes each second on an Amazon RDS for MySQL Multi- AZ DB instance with General Purpose SSD (gp2) storage. After comprehensive testing and analysis, a database specialist discovers that there is high read latency and high CPU utilization on the DB instance.
Which approach should the database specialist to take to resolve this issue without changing the application?

• A.Use the same RDS for MySQL instance class with Provisioned IOPS (PIOPS) storage.
• B.Implementing sharding to distribute the load to multiple RDS for MySQL databases.
• C.Modify the RDS for MySQL database class to a bigger size and implement Provisioned IOPS (PIOPS).
• D.Add an RDS for MySQL read replica.

Comment: *

Name: *

Email: *

Verification: *