{"id":642,"date":"2022-03-14T05:37:07","date_gmt":"2022-03-14T05:37:07","guid":{"rendered":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/aws-certified-database-specialty-question197\/"},"modified":"2022-03-14T05:37:07","modified_gmt":"2022-03-14T05:37:07","slug":"aws-certified-database-specialty-question197","status":"publish","type":"post","link":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/aws-certified-database-specialty-question197\/","title":{"rendered":"AWS Certified Database &#8211; Specialty &#8211; Question197"},"content":{"rendered":"<div class=\"question\">A company has an on-premises production Microsoft SQL Server with 250 GB of data in one database. A database specialist needs to migrate this on-premises SQL Server to Amazon RDS for SQL Server. The nightly native SQL Server backup file is approximately 120 GB in size. The application can be down for an extended period of time to complete the migration. Connectivity between the on-premises environment and AWS can be initiated from on-premises only.<br \/>\nHow can the database be migrated from on-premises to Amazon RDS with the LEAST amount of effort?<br \/><strong><br \/>A.<\/strong> Back up the SQL Server database using a native SQL Server backup. Upload the backup files to Amazon S3. Download the backup files on an Amazon EC2 instance and restore them from the EC2 instance into the new production RDS instance.<br \/><strong>B.<\/strong> Back up the SQL Server database using a native SQL Server backup. Upload the backup files to Amazon S3. Restore the backup files from the S3 bucket into the new production RDS instance.<br \/><strong>C.<\/strong> Provision and configure AWS DMS. Set up replication between the on-premises SQL Server environment to replicate the database to the new production RDS instance.<br \/><strong>D.<\/strong> Back up the SQL Server database using AWS Backup. Once the backup is complete, restore the completed backup to an Amazon EC2 instance and move it to the new production RDS instance.<\/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>B<\/strong><\/div>\n<p><strong>Explanation:<\/strong> <\/p>\n<div class=\"explanation\">\nReference: <a href=\"https:\/\/www.sqlshack.com\/aws-rds-sql-server-migration-using-native-backups\/\" title=\"External link\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/www.sqlshack.com\/aws-rds-sql-server-migration-using-native-&#8230;<\/a><br \/>\n<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full\" src=\"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-content\/uploads\/exam\/0197-0000.jpg\" \/><\/div>\n<p><\/strong><\/span> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>A company has an on-premises production Microsoft SQL Server with 250 GB of data in one database. A database specialist needs to migrate this on-premises SQL Server to Amazon RDS for SQL Server. The nightly native SQL Server backup file is approximately 120 GB in size. The application can be down for an extended period [&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,200],"class_list":["post-642","post","type-post","status-publish","format-standard","hentry","category-aws-certified-database-specialty","tag-aws-certified-database-specialty","tag-question-197"],"_links":{"self":[{"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/posts\/642","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=642"}],"version-history":[{"count":0,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/posts\/642\/revisions"}],"wp:attachment":[{"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/media?parent=642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/categories?post=642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exampracticetests.com\/aws\/Database-Specialty\/wp-json\/wp\/v2\/tags?post=642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}