DBS-C01 · Question #242
A company is using an Amazon Aurora MySQL database with Performance Insights enabled. A database specialist is checking Performance Insights and observes an alert message that starts with the…
The correct answer is A. Truncate the events_statements_summary_by_digest table. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_PerfInsights.UsingDa shboard.AnalyzeDBLoad.AdditionalMetrics.MySQL.html
Question
A company is using an Amazon Aurora MySQL database with Performance Insights enabled. A database specialist is checking Performance Insights and observes an alert message that starts with the following phrase:
Performance Insights is unable to collect SQL Digest statistics on new queries Which action will resolve this alert message?
Options
- ATruncate the events_statements_summary_by_digest table.
- BChange the AWS Key Management Service (AWS KMS) key that is used to enable Performance
- CSet the value for the performance_schema parameter in the parameter group to 1.
- DDisable and reenable Performance Insights to be effective in the next maintenance window.
How the community answered
(49 responses)- A86% (42)
- B2% (1)
- C4% (2)
- D8% (4)
Explanation
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_PerfInsights.UsingDa shboard.AnalyzeDBLoad.AdditionalMetrics.MySQL.html
Topics
Community Discussion
No community discussion yet for this question.