AWS Certified Developer Associate DVA-C02 Practice Question
A developer is troubleshooting an application that intermittently fails to connect to an Amazon RDS database instance. The logs indicate occasional connection timeouts. The application and database have not been modified recently, and there is no predictable pattern for the timeout occurrences. After ensuring there are no network issues and the database is healthy, what should the developer investigate NEXT to identify the root cause?
Review the application's usage of Amazon SQS to check for any unprocessed messages accumulating in a dead-letter queue.
Analyze the application's interaction with the Amazon EC2 instance to gauge the processing time of web requests.
Inspect the number of database connections and ensure proper management in the application's connection pooling configuration.
Profile the application code to identify any performance bottlenecks that could cause delays.
Enable AWS X-Ray tracing for in-depth analysis of the underlying Lambda function's execution flow.
Check for any misconfigured request headers impacting CloudFront distributions, assuming it serves content to the application.