ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 232 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 232
Topic #: 1
[All AWS Certified Database - Specialty Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by mbar94 at Sept. 7, 2022, 9:56 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Sathish_dbs
2 years, 3 months ago
C is opposite. performance_schema parameter must be set to 0
upvoted 1 times
Sathish_dbs
2 years, 3 months ago
For automatic management. so that it can automatically truncate the table
upvoted 1 times
Sathish_dbs
2 years, 3 months ago
if not truncate table manually events_statements_summary_by_digest
upvoted 1 times
...
...
...
Goram113
2 years, 5 months ago
In this situation, MariaDB and MySQL don't track SQL queries. To address this issue, Performance Insights automatically truncates the digest table when both of the following conditions are met: The table is full. Performance Insights manages the Performance Schema automatically. For automatic management, the performance_schema parameter must be set to 0 and the Source must not be set to user. If Performance Insights isn't managing the Performance Schema automatically, see Turning on the Performance Schema for Performance Insights on Amazon RDS for MariaDB or MySQL.
upvoted 1 times
...
cloudsunriser
2 years, 6 months ago
Selected Answer: A
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.UsingDashboard.AnalyzeDBLoad.AdditionalMetrics.MySQL.html
upvoted 2 times
...
SonamDhingra
2 years, 7 months ago
Selected Answer: A
A is correct https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.UsingDashboard.AnalyzeDBLoad.AdditionalMetrics.MySQL.html
upvoted 4 times
...
mbar94
2 years, 7 months ago
Selected Answer: A
Agree, it's A.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago