{"id":625,"date":"2022-03-14T05:36:49","date_gmt":"2022-03-14T05:36:49","guid":{"rendered":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/aws-certified-database-specialty-question180\/"},"modified":"2022-03-14T05:36:49","modified_gmt":"2022-03-14T05:36:49","slug":"aws-certified-database-specialty-question180","status":"publish","type":"post","link":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/aws-certified-database-specialty-question180\/","title":{"rendered":"AWS Certified Database &#8211; Specialty &#8211; Question180"},"content":{"rendered":"<div class=\"question\">A media company wants to use zero-downtime patching (ZDP) for its Amazon Aurora MySQL database.<br \/>\nMultiple processing applications are using SSL certificates to connect to database endpoints and the read replicas.<br \/>\nWhich factor will have the LEAST impact on the success of ZDP?<br \/><strong><br \/>A.<\/strong> Binary logging is enabled, or binary log replication is in progress.<br \/><strong>B.<\/strong> Current SSL connections are open to the database.<br \/><strong>C.<\/strong> Temporary tables or table locks are in use.<br \/><strong>D.<\/strong> The value of the lower_case_table_names server parameter was set to 0 when the tables were created.<\/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>A<\/strong><\/div>\n<p><strong>Explanation:<\/strong> <\/p>\n<div class=\"explanation\">\nExplanation:<br \/>\nAurora MySQL 2.10 and higher, Aurora can perform a zero-downtime patch when binary log replication is enabled.<br \/>\nReference: <a href=\"https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/AuroraUserGuide\/AuroraMySQL.Updates.Patching.html\" title=\"External link\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/AuroraUserGuide\/Aurora&#8230;<\/a><\/div>\n<p><\/strong><\/span> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>A media company wants to use zero-downtime patching (ZDP) for its Amazon Aurora MySQL database. Multiple processing applications are using SSL certificates to connect to database endpoints and the read replicas. Which factor will have the LEAST impact on the success of ZDP?A. Binary logging is enabled, or binary log replication is in progress.B. Current [&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,183],"class_list":["post-625","post","type-post","status-publish","format-standard","hentry","category-aws-certified-database-specialty","tag-aws-certified-database-specialty","tag-question-180"],"_links":{"self":[{"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/posts\/625","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=625"}],"version-history":[{"count":0,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/posts\/625\/revisions"}],"wp:attachment":[{"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/media?parent=625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/categories?post=625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/tags?post=625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}