A company uses an Amazon RDS MySQL database to store data for several applications. The company wants to understand use patterns for the database so…

Amazon RDS Performance Insights is a database performance tuning and monitoring feature specifically designed to help users assess the load on their database. It provides a visual dashboard that helps identify the most resource-intensive SQL queries and other factors contributing to the database load, such as CPU utilization. By enabling Performance Insights, a solutions architect can easily visualize the database's performance profile, including peak and average CPU usage, over time. This data is crucial for making informed right-sizing decisions to optimize costs by selecting an instance type that matches the actual workload, thereby meeting the requirements with the least possible effort.

A. AWS CloudTrail logs API calls to the AWS environment, not internal database transactions. It is the wrong tool for analyzing database workload for right-sizing purposes.

C. AWS X-Ray traces user requests through an application, which requires instrumenting application code. It is not designed for deep database instance performance analysis for right-sizing.

D. This requires significant custom development to instrument applications to send relevant data to CloudWatch Logs and then build a separate process to aggregate and analyze it.

1. Amazon RDS User Guide

"Monitoring metrics in an Amazon RDS instance": "Amazon RDS Performance Insights monitors your DB instance load so that you can analyze and troubleshoot your database performance... With Performance Insights

you can identify your most resource-intensive SQL queries." This directly supports using Performance Insights to understand database usage patterns.

2. Amazon RDS User Guide

"Using the Performance Insights dashboard": The Performance Insights dashboard includes a "Counter metrics" chart which displays performance counters

including CPUUtilization. This confirms that Performance Insights provides the key metric mentioned in the correct answer for right-sizing.

3. AWS Documentation

"AWS CloudTrail User Guide"

"Logging Amazon RDS API calls in AWS CloudTrail": This guide specifies that CloudTrail captures API calls for RDS management actions (e.g.

CreateDBInstance)

not the internal SQL queries needed to analyze workload.

4. AWS Documentation

"AWS X-Ray Developer Guide"

"What is AWS X-Ray?": "AWS X-Ray helps developers analyze and debug production

distributed applications...". This shows X-Ray's focus is on application tracing

not standalone database instance analysis

and requires application-level integration.