DBS-C01 · Question #207
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 n
Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #207. The question stem and answer options stay visible for context.
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. How can the database be migrated from on-premises to Amazon RDS with the LEAST amount of effort?
Options
- ABack up the SQL Server database using a native SQL Server backup. Upload the backup files to
- BBack up the SQL Server database using a native SQL Server backup. Upload the backup files to
- CProvision and configure AWS DMS. Set up replication between the on-premises SQL Server
- DBack up the SQL Server database using AWS Backup. Once the backup is complete, restore the
Unlock DBS-C01 to see the answer
You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.