Assess schemas with SCT and move the database fleet with DMS

SAP-C02 By islever Editorial Last updated

Determine the optimal migration approach for existing workloads. Select existing workloads and processes for potential migration. Determine a new architecture for existing workloads.

Short answer

CD Use AWS SCT to analyse the source schemas for required changes and AWS DMS to migrate the data to Amazon RDS.

Question

A company needs to migrate its on-premises database fleet to Amazon RDS. The company is currently using a mixture of Microsoft SQL Server, MySQL, and Oracle databases. Some of the databases have custom schemas and stored procedures. Which combination of steps should the company take for the migration? (Choose two.)
  1. Use Migration Evaluator Quick Insights to analyze the source databases and to identify the stored procedures that need to be migrated.
  2. Use AWS Application Migration Service to analyze the source databases and to identify the stored procedures that need to be migrated.
  3. Use the AWS Schema Conversion Tool (AWS SCT) to analyze the source databases for changes that are required Correct Answer
  4. Use AWS Database Migration Service (AWS DMS) to migrate the source databases to Amazon RDS. Correct Answer
  5. Use AWS DataSync to migrate the data from the source databases to Amazon RDS.

Key Takeaways

The assessment and the movement are different jobs requiring different tools: Schema Conversion Tool reports the schema and code changes a heterogeneous fleet will need, and Database Migration Service performs the actual data replication into RDS.

A company must migrate an on-premises database fleet of mixed SQL Server, MySQL, and Oracle databases to Amazon RDS, and some of those databases contain custom schemas and stored procedures. The migration has to be planned for the code that lives alongside the data.

Common mistake: Using Application Migration Service or Migration Evaluator to find the stored procedures. Application Migration Service replicates whole servers for lift-and-shift rather than analysing database code, and Migration Evaluator produces cost and inventory assessments rather than a list of stored procedures that must be rewritten.

Expert Analysis

Why the Answer Is Correct

Because the fleet is heterogeneous and includes custom schemas and stored procedures, the company first needs to know what has to change, which is what the AWS Schema Conversion Tool provides. SCT assesses the source schemas and reports the conversion issues and code changes required for the target engine, including objects such as stored procedures that do not translate automatically. AWS Database Migration Service then performs the migration, replicating the data and, where needed, ongoing change data capture into the Amazon RDS instances. Using the two tools together covers assessment and movement, which is what the requirement describes.

Why the Other Options Are Wrong

A: Migration Evaluator produces inventory and cost modelling for a migration, and its Quick Insights do not enumerate stored procedures or schema incompatibilities, so it cannot inform the code changes the fleet needs. B: AWS Application Migration Service discovers and replicates whole servers for a lift-and-shift migration, and it does not analyse database schemas or identify stored procedures, so it is the wrong tool for this requirement. E: AWS DataSync moves files and object data between storage locations and does not perform database replication into RDS, so it cannot migrate these database instances.

Community Comment Notes

The community voted 100 to 0 for C and D, and the top-voted comments gave the reasons directly, SCT for identifying the required changes and DMS for performing the migration. A commenter expanded on why the other options fail, noting there is no service named Migration Evaluator Quick Insights for this purpose, that Application Migration Service is primarily for migrating virtual machines rather than analysing them, and that DataSync is not a database migration tool.

Official Reference

https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html

This link opens the official vendor documentation in a new tab.

Community Votes

CD
100%

100% of anonymous learners picked answer CD. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 5 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 5

  1. liuliangzhou 👍 1
    A. AWS does not have a service directly named 'Migration Evaluator Quick Insights'. B. AWS Application Migration Service is primarily used for migrating virtual machines rather than analyzing them. C. AWS SCT can analyze the source database and identify potential architecture changes needed for successful migration to Amazon RDS. D. AWS DMS is a data migration service. E. AWS DataSync is a service used for quickly migrating large amounts of data between local storage and AWS storage services, with a focus on file level data migration. But database migration requires maintaining data integrity, relationships, constraints, and so on.
  2. AzureDP900 👍 1
    CD Using both AWS SCT and AWS DMS will provide the necessary tools for a successful database migration. AWS SCT helps with identifying the changes needed during migration, while AWS DMS provides a managed service for executing the migration.
  3. kupo777 👍 1
    B AWS Database Migration Service can convert Oracle and SQL Server to Amazon RDS for MySQL and Amazon RDS for PostgreSQL stored procedures. D AWS Database Migration Service (AWS DMS) performs data migration. The answer is DB.
  4. ebbff63 👍 7
    Answer CD
  5. awsaz 👍 4
    C and D

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Modernize centralized firewall appliances with a Gateway Load Balancer and Auto Scaling

S-grade

Use Lambda over a CloudWatch Logs stream to count unique users per client

S-grade

Serve global game assets with Route 53 latency records and health checks

S-grade

Reach a cross-account S3 data lake through a gateway endpoint and an access point bucket policy

S-grade

Practice All SAP-C02 Questions

Access 85 questions with complete answers and detailed explanations.

View Full SAP-C02 Practice Test →

← Back to SAP-C02 Study Guide