AWS Certified Database – Specialty — Question 348

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?

Answer options

• A. Truncate the events_statements_summary_by_digest table.
• B. Change the AWS Key Management Service (AWS KMS) key that is used to enable Performance Insights.
• C. Set the value for the performance_schema parameter in the parameter group to 1.
• D. Disable and reenable Performance Insights to be effective in the next maintenance window.

Correct answer: A

Explanation

This alert indicates that the Performance Schema digest memory buffer has reached its capacity limit and can no longer track new SQL statements. Truncating the events_statements_summary_by_digest table clears the accumulated statistics, resolving the issue and allowing Performance Insights to resume collection. Modifying KMS keys, changing the performance_schema parameter, or restarting Performance Insights will not clear the full digest table.