{"id":619,"date":"2022-03-14T05:36:43","date_gmt":"2022-03-14T05:36:43","guid":{"rendered":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/aws-certified-database-specialty-question174\/"},"modified":"2022-03-14T05:36:43","modified_gmt":"2022-03-14T05:36:43","slug":"aws-certified-database-specialty-question174","status":"publish","type":"post","link":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/aws-certified-database-specialty-question174\/","title":{"rendered":"AWS Certified Database &#8211; Specialty &#8211; Question174"},"content":{"rendered":"<div class=\"question\">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.<br \/>\nReviewing Amazon CloudWatch metrics for the Aurora DB cluster showed 90% CPU utilization.<br \/>\nWhich steps should the database specialist take to MOST effectively identify the root cause of high CPU utilization and slow performance? (Choose two.)<br \/><strong><br \/>A.<\/strong> Enable Enhanced Monitoring at less than 30 seconds of granularity to review the operating system metrics before the next round of tests.<br \/><strong>B.<\/strong> Review the VolumeBytesUsed metric in CloudWatch to see if there is a spike in write I\/O.<br \/><strong>C.<\/strong> Review Amazon RDS Performance Insights to identify the top SQL statements and wait events.<br \/><strong>D.<\/strong> Review Amazon RDS API calls in AWS CloudTrail to identify long-running queries.<br \/><strong>E.<\/strong> Enable Advance Auditing to log QUERY events in Amazon CloudWatch before the next round of tests.<\/div>\n<p><\/p>\n<style> .hidden-div{ display:none } <\/style>\n<p>\t\t\t\t\t\t\t<button onclick=\"getElementById('hidden-div').style.display = 'block'\"> Show Answer <\/button> <button onclick=\"getElementById('hidden-div').style.display = 'none'\">Hide Answer<\/button><\/p>\n<div class=\"hidden-div\" id=\"hidden-div\"><span style=\"\"><\/p>\n<div class=\"answer\">Correct Answer: <strong>BC<\/strong><\/div>\n<p><strong>Explanation:<\/strong> <\/p>\n<div class=\"explanation\">\nReference: <a href=\"https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/UserGuide\/USER_PerfInsights.API.html\" title=\"External link\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/UserGuide\/USER_PerfIns&#8230;<\/a><br \/>\n<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full\" src=\"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-content\/uploads\/exam\/0174-0000.jpg\" \/><\/div>\n<p><\/strong><\/span> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[3,177],"class_list":["post-619","post","type-post","status-publish","format-standard","hentry","category-aws-certified-database-specialty","tag-aws-certified-database-specialty","tag-question-174"],"_links":{"self":[{"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/posts\/619","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/comments?post=619"}],"version-history":[{"count":0,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/posts\/619\/revisions"}],"wp:attachment":[{"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/media?parent=619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/categories?post=619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/tags?post=619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}