nerdexam
Amazon

SAP-C02 · Question #496

A solutions architect is planning to migrate critical Microsoft SQL Server databases to AWS. Because the databases are legacy systems, the solutions architect will move the databases to a modern…

The correct answer is C. Use native database high availability tools. Connect the source system to an Amazon RDS for. https://aws.amazon.com/blogs/database/part-3-migrating-to-amazon-rds-for-sql-server-using- transactional-replication-with-native-backup-and-restore/

Submitted by fatima_kr· Mar 6, 2026Migrate Workloads and Modernize Solutions

Question

A solutions architect is planning to migrate critical Microsoft SQL Server databases to AWS. Because the databases are legacy systems, the solutions architect will move the databases to a modern data architecture. The solutions architect must migrate the databases with near-zero downtime. Which solution will meet these requirements?

Options

  • AUse AWS Application Migration Service and the AWS Schema Conversion Tool (AWS SCT).
  • BUse AWS Database Migration Service (AWS DMS) to rehost the database. Set Amazon S3 as a
  • CUse native database high availability tools. Connect the source system to an Amazon RDS for
  • DUse AWS Application Migration Service. Rehost the database server on Amazon EC2. When

How the community answered

(31 responses)
  • A
    6% (2)
  • B
    3% (1)
  • C
    81% (25)
  • D
    10% (3)

Explanation

https://aws.amazon.com/blogs/database/part-3-migrating-to-amazon-rds-for-sql-server-using- transactional-replication-with-native-backup-and-restore/

Community Discussion

No community discussion yet for this question.

Full SAP-C02 Practice