A application which has a MySQL RDS database, becomes unresponsive from time to time. You were instructed to collect all SQL statements that took longer to execute for troubleshooting. What is the proper way to get all these reports for troubleshooting.

Question

Enable slow query log in RDS.
Instrument your application using the X-Ray SDK.
Enable active tracing using AWS X-Ray.
Use Amazon Inspector to get all the slow queries.

Solutons With Key Points

Answer- A

Related Questions

Regarding the AWS Elastic Beanstalk, if the environment health is grey, __________________.
A user is creating multiple IAM users. What advice should be given to him to enhance the security?
A user is running a webserver on EC2. The user wants to receive the SMS when the EC2 instance utilization is above the threshold limit. Which AWS services should the user configure in this case?
John is an architect and he has developed an application which is required to send the data to a NoSQL database. John now wants to decouple the data sending such that the application keeps processing and sending data but does not wait for an acknowledgement of DB. Which of the below mentioned applications helps in this scenario?
A cloud developer has created a MySQL RDS instance with PIOPS. Which of the below mentioned statements will help the developer to understand the advantage of PIOPS?
Your friend is planning to use the AWS RDS with MySQL. Which of the below mentioned services is he not going to pay for?
A Lambda-based application consists of several functions. Once triggered, these functions will call various downstream resources such as a DynamoDB table or an S3 bucket, or make other API calls. How can be achived by the developer to trace the event source that invoked your Lambda functions and trace the downstream calls that your functions made.
A developer uses AWS SAM templates to deploy a serverless application. He needs to embed the application from the AWS Serverless Application Repository or from an S3 bucket as a nested application. Which of the following will be suitable to achived this.
A Lambda function has been integrated with DynamoDB Streams as its event source. There has been a new version of the function that needs to be deployed using CodeDeploy where the traffic must be shifted in two increments. It should shift 10 percent of the incoming traffic to the new version in the first increment and then the remaining 90 percent should be deployed five minutes later.Which of the following deployment configurations is the MOST suitable to satisfy this requirement?
You have a private S3 bucket that stores application logs and the bucket contents are accessible to all members of the Developer IAM group. However, you want to make an object inside the bucket which should only be accessible to the members of Admin IAM group. �How can you apply an S3 bucket policy to this object using AWS CLI?

More Test for Practice

Developer Associate AWS certification Set - 1
Developer Associate AWS certification Set - 2
Developer Associate AWS certification Set - 3
Developer Associate AWS certification Set - 4

AWS certification

Developer Associate AWS certification