nerdexam
Amazon

DBS-C01 · Question #307

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

Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #307. The question stem and answer options stay visible for context.

Submitted by kim_seoul· Mar 6, 2026Deployment and Migration

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

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.

Topics

#database migration#SQL Server migration#AWS DMS#AWS SCT
Full DBS-C01 Practice