You are migrating a 200 GB database from an on-premise SQL Server to RDS for SQL Server. The database needs to have minimal downtime during the migration. What is the best practice for migrating this database?

Digital Marketing, LinkedIn Amazon Web Services (AWS) Skill Quiz Answers

You no longer need to be worried if you are taking the LinkedIn Amazon Web Services (AWS) Skill Quiz Exam and are unsure about the proper answer to the question “You are migrating a 200 GB database from an on-premise SQL Server to RDS for SQL Server. The database needs to have minimal downtime during the migration. What is the best practice for migrating this database?”. I have provided the right answer to your question below.

You are migrating a 200 GB database from an on-premise SQL Server to RDS for SQL Server. The database needs to have minimal downtime during the migration. What is the best practice for migrating this database?

Options

  • Close all existing connections to the SQL Server database and use Database Migration Service to transfer the data to RDS.
  • Detach the SQL Server database during the migration. Take a backup of the database and use SQ with Accelerated Transfer to upload the backups to S3. Restore the backups to the RDS instance.
  • Use the Import and Export wizard within SQL Server Enterprise Manager to create an export task and export the tables to the RDS instance.
  • Use Database Migration Service to replicate the database to RDS and keep it in sync during the migration. Repoint your applications to use the new RDS endpoint.

The Correct Answer Is:

  • Use Database Migration Service to replicate the database to RDS and keep it in sync during the migration. Repoint your applications to use the new RDS endpoint.

Conclusion

I believe I was successful in answering your query “You are migrating a 200 GB database from an on-premise SQL Server to RDS for SQL Server. The database needs to have minimal downtime during the migration. What is the best practice for migrating this database?”. I hope you easily pass the certification exam and get the certificate as soon as possible. Have a great time! Good luck!