{"id":611,"date":"2022-03-14T05:36:35","date_gmt":"2022-03-14T05:36:35","guid":{"rendered":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/aws-certified-database-specialty-question166\/"},"modified":"2022-03-14T05:36:35","modified_gmt":"2022-03-14T05:36:35","slug":"aws-certified-database-specialty-question166","status":"publish","type":"post","link":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/aws-certified-database-specialty-question166\/","title":{"rendered":"AWS Certified Database &#8211; Specialty &#8211; Question166"},"content":{"rendered":"<div class=\"question\">A company is migrating an IBM Informix database to a Multi-AZ deployment of Amazon RDS for SQL Server with Always On Availability Groups (AGs). SQL Server Agent jobs on the Always On AG listener run at 5-minute intervals to synchronize data between the Informix database and the SQL Server database.<br \/>\nUsers experience hours of stale data after a successful failover to the secondary node with minimal latency.<br \/>\nWhat should a database specialist do to ensure that users see recent data after a failover?<br \/><strong><br \/>A.<\/strong> Set TTL to less than 30 seconds for cached DNS values on the Always On AG listener.<br \/><strong>B.<\/strong> Break up large transactions into multiple smaller transactions that complete in less than 5 minutes.<br \/><strong>C.<\/strong> Set the databases on the secondary node to read-only mode.<br \/><strong>D.<\/strong> Create the SQL Server Agent jobs on the secondary node from a script when the secondary node takes over after a failure.<\/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>C<\/strong><\/div>\n<p><strong>Explanation:<\/strong> <\/p>\n<div class=\"explanation\">\nExplanation:<br \/>\nAfter a failover, client applications that need to access the primary databases must connect to the new primary replica. Also, if the new secondary replica is configured to allow read-only access, read-only client applications can connect to it.<br \/>\nReference: <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/availability-groups\/windows\/failover-and-failover-modes-always-on-availability-groups?view=sql-server-ver15\" title=\"External link\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/availability-g&#8230;<\/a><\/div>\n<p><\/strong><\/span> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>A company is migrating an IBM Informix database to a Multi-AZ deployment of Amazon RDS for SQL Server with Always On Availability Groups (AGs). SQL Server Agent jobs on the Always On AG listener run at 5-minute intervals to synchronize data between the Informix database and the SQL Server database. Users experience hours of stale [&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,169],"class_list":["post-611","post","type-post","status-publish","format-standard","hentry","category-aws-certified-database-specialty","tag-aws-certified-database-specialty","tag-question-166"],"_links":{"self":[{"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/posts\/611","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=611"}],"version-history":[{"count":0,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/posts\/611\/revisions"}],"wp:attachment":[{"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/media?parent=611"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/categories?post=611"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/tags?post=611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}