DBS-C01 · Question #307
DBS-C01 Question #307: Real Exam Question with Answer & Explanation
The correct answer is B: Use AWS Database Migration Service (AWS DMS) and the AWS Schema Conversion Tool (AWS. https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-a-microsoft-sql- server-database-to-aurora-mysql-by-using-aws-dms-and-aws-sct.html
Question
A global company needs to migrate from an on-premises Microsoft SQL Server database to a highly available database solution on AWS. The company wants to modernize its application and keep operational costs low. The current database includes secondary indexes and stored procedures that need to be included in the migration. The company has limited availability of database specialists to support the migration and wants to automate the process. Which solution will meet these requirements?
Options
- AUse AWS Database Migration Service (AWS DMS) to migrate all database objects from the on-
- BUse AWS Database Migration Service (AWS DMS) and the AWS Schema Conversion Tool (AWS
- CRehost the on-premises SQL Server as a SQL Server Always On availability group. Host
- DRehost the on-premises SQL Server as a SQL Server Always On availability group. Host
Explanation
https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-a-microsoft-sql- server-database-to-aurora-mysql-by-using-aws-dms-and-aws-sct.html
Topics
Community Discussion
No community discussion yet for this question.