A development team is experiencing performance issues with their Amazon RDS instance. They wish to measure database load and identify SQL commands with a high CPU load. What service can the team use to help them solve this issue?

Answer options:

A.CloudTrail Insights Events
B.CloudWatch Enhanced Monitoring
C.Inspector assessment report
D.RDS Performance Insights

Answer: D
Option A is incorrect because CloudTrail is a service for logging and storing AWS account and service API activity, not application logs. CloudTrail Insights is a feature that helps identify and alert any abnormal activity in the AWS account.
Option B is incorrect because CloudWatch collects performance metrics of EC2 instances, not Amazon RDS instances. Further, it collects host-level metrics and cannot identify issues relating to individual SQL queries.
Option C is incorrect because AWS Inspector is a network and security assessment service. It performs an assessment of EC2 instances for network vulnerabilities (e.g., exposed ports), Common Vulnerabilities and Exposures (CVE), and compares OS configurations to CIS security benchmarks. It is not used for collecting logs or correlating errors.
Option D is CORRECT because Amazon RDS Performance Insights collects key performance metrics of Amazon RDS DB instances and identifies SQL queries that create high database load. It can help in tuning and improving RDS database performance.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.html