Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 174 discussion

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

An ecommerce company is migrating its core application database to Amazon Aurora MySQL. The company is currently performing online transaction processing
(OLTP) stress testing with concurrent database sessions. During the first round of tests, a database specialist noticed slow performance for some specific write operations.
Reviewing Amazon CloudWatch metrics for the Aurora DB cluster showed 90% CPU utilization.
Which steps should the database specialist take to MOST effectively identify the root cause of high CPU utilization and slow performance? (Choose two.)

  • A. Enable Enhanced Monitoring at less than 30 seconds of granularity to review the operating system metrics before the next round of tests.
  • B. Review the VolumeBytesUsed metric in CloudWatch to see if there is a spike in write I/O.
  • C. Review Amazon RDS Performance Insights to identify the top SQL statements and wait events.
  • D. Review Amazon RDS API calls in AWS CloudTrail to identify long-running queries.
  • E. Enable Advance Auditing to log QUERY events in Amazon CloudWatch before the next round of tests.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️
by jelongpark at Nov. 17, 2021, 8:08 p.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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
jelongpark
Highly Voted 2 years, 12 months ago
A,C i smy pick. B: VolumeBytesUsed metric is for total used storage size, not for CPU
upvoted 15 times
...
rags1482
Most Recent 2 years ago
https://aws.amazon.com/premiumsupport/knowledge-center/rds-instance-high-cpu/ A, C is the answer
upvoted 1 times
...
awsjjj
2 years, 1 month ago
Selected Answer: AC
E is for auditing including query events. For performance I go with A and C
upvoted 1 times
...
venimus_vidimus_vicimus
2 years, 1 month ago
Selected Answer: AE
Guys.. why are you all Posting RDS Docs Links? This Question is about Aurora which is why I go with A and E
upvoted 2 times
ixdb
1 year, 7 months ago
Performance Insights is currently available for Amazon Aurora PostgreSQL compatible Edition, MySQL compatible Edition, PostgreSQL, MySQL, Oracle, SQL Server, and MariaDB.
upvoted 1 times
...
lehoang15tuoi
1 year, 5 months ago
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_PerfInsights.Overview.html you can use Perf Insight in *Aurora* to identify the most heavy-hitting queries. Nobody uses Advance Auditing to solve performance problems...
upvoted 2 times
...
...
venimus_vidimus_vicimus
2 years, 1 month ago
Guys.. why are you all Posting RDS Docs Links? This Question is about Aurora which is why I go with A and E
upvoted 1 times
...
shammous
2 years, 3 months ago
Selected Answer: AC
A,C are related to performance. B is related to storage. D is related to security (API calls tracking) and E (Advanced Auditing) does not exist.
upvoted 1 times
Jiang_aws1
2 years, 1 month ago
Using Advanced Auditing with an Amazon Aurora MySQL DB cluster https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Auditing.html
upvoted 1 times
...
...
novice_expert
2 years, 6 months ago
Selected Answer: AC
https://aws.amazon.com/premiumsupport/knowledge-center/rds-instance-high-cpu/ A. Enhanced Monitoring checks OS xB. VolumeBytesUsed is the amount of storage used C. Performance Insights
upvoted 2 times
...
tugboat
2 years, 8 months ago
Selected Answer: AC
Per - https://aws.amazon.com/premiumsupport/knowledge-center/rds-mysql-slow-query/ To analyze the workload contributing to resource consumption, use Performance Insights. Performance Insights will provide a graphic analysis of all your queries and any waits that are contributing to increased resource consumption. You can also use Enhanced Monitoring to retrieve the list of operating systems involved in your workload and the underlying system metrics. By default, the monitoring interval for Enhanced Monitoring is 60 seconds. It's a best practice to set this to 1-5 second intervals for more granular data points.
upvoted 2 times
...
kped21
2 years, 8 months ago
A,C : PI and Enhanced Monitoring
upvoted 1 times
...
123xjuanperez
2 years, 11 months ago
A,C is the solution
upvoted 1 times
...
nood
2 years, 11 months ago
A,C for me https://aws.amazon.com/premiumsupport/knowledge-center/rds-instance-high-cpu/
upvoted 1 times
...
grekh001
2 years, 11 months ago
A and C is correct. https://aws.amazon.com/premiumsupport/knowledge-center/rds-mysql-slow-query/
upvoted 1 times
...
IshtarSQL
2 years, 11 months ago
C,D is my choice https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/logging-using-cloudtrail.html :"enableCloudwatchLogsExports": [ "audit", "error", "general", "slowquery"
upvoted 1 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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