SAA-C03 Question #554: Real Exam Question with Answer & Explanation

Question

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 the company can identify oppor- tunities to optimize costs. A solutions architect needs to analyze the RDS DB instance to identify right-sizing opportuni-ties. Which solution will meet these requirements with the LEAST effort?

Options

• AEnable AWS CloudTrail data events. Use Amazon Athena to query CloudTrail events. Right-size
• BEnable Performance Insights for the RDS DB instance. Right-size the RDS DB instance based on
• CEnable AWS X-Ray to understand the transactions that run on the RDS DB instance. Right-size
• DEnable Amazon CloudWatch Logs for the applications. Aggregate the data from Cloud-Watch

Explanation

Amazon RDS Performance Insights is a "database performance tuning and monitoring feature" that can be enabled with a few clicks and "helps you quickly assess the load on your database" and identify bottlenecks. It surfaces key metrics, including DB load, top SQL, waits, and host metrics such as CPU utilization, which are commonly used indicators for right-sizing (up or down). This provides the lowest operational effort compared to building log pipelines or querying CloudTrail (which does not capture SQL workload characteristics). AWS X-Ray traces application requests, not database internals, and CloudWatch Logs aggregation requires custom ingestion and analysis. Enabling Performance Insights directly on the RDS instance provides actionable utilization data to right-size with minimal setup.

No community discussion yet for this question.