{"id":628,"date":"2022-03-14T05:36:52","date_gmt":"2022-03-14T05:36:52","guid":{"rendered":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/aws-certified-database-specialty-question183\/"},"modified":"2022-03-14T05:36:52","modified_gmt":"2022-03-14T05:36:52","slug":"aws-certified-database-specialty-question183","status":"publish","type":"post","link":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/aws-certified-database-specialty-question183\/","title":{"rendered":"AWS Certified Database &#8211; Specialty &#8211; Question183"},"content":{"rendered":"<div class=\"question\">A company is migrating a database in an Amazon RDS for SQL Server DB instance from one AWS Region to another. The company wants to minimize database downtime during the migration.<br \/>\nWhich strategy should the company choose for this cross-Region migration?<br \/><strong><br \/>A.<\/strong> Back up the source database using native backup to an Amazon S3 bucket in the same Region. Then restore the backup in the target Region.<br \/><strong>B.<\/strong> Back up the source database using native backup to an Amazon S3 bucket in the same Region. Use Amazon S3 Cross-Region Replication to copy the backup to an S3 bucket in the target Region. Then restore the backup in the target Region.<br \/><strong>C.<\/strong> Configure AWS Database Migration Service (AWS DMS) to replicate data between the source and the target databases. Once the replication is in sync, terminate the DMS task.<br \/><strong>D.<\/strong> Add an RDS for SQL Server cross-Region read replica in the target Region. Once the replication is in sync, promote the read replica to master.<\/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 \/>\nAmazon RDS supports native backup and restore for Microsoft SQL Server databases using full backup files (.bak files). When you use RDS, you access files stored in Amazon S3 rather than using the local file system on the database server.<br \/>\nReference: <a href=\"https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/UserGuide\/SQLServer.Procedural.Importing.html\" title=\"External link\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/UserGuide\/SQLServer.Pr&#8230;<\/a><\/div>\n<p><\/strong><\/span> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>A company is migrating a database in an Amazon RDS for SQL Server DB instance from one AWS Region to another. The company wants to minimize database downtime during the migration. Which strategy should the company choose for this cross-Region migration?A. Back up the source database using native backup to an Amazon S3 bucket in [&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,186],"class_list":["post-628","post","type-post","status-publish","format-standard","hentry","category-aws-certified-database-specialty","tag-aws-certified-database-specialty","tag-question-183"],"_links":{"self":[{"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/posts\/628","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=628"}],"version-history":[{"count":0,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/posts\/628\/revisions"}],"wp:attachment":[{"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/media?parent=628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/categories?post=628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/tags?post=628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}