SAA-C03 · Question #774
SAA-C03 Question #774: Real Exam Question with Answer & Explanation
The correct answer is C: Use AWS Schema Conversion Tool (AWS SCT) to translate the database schema to Amazon. For a heterogeneous database migration (SQL Server to MySQL), AWS Schema Conversion Tool (SCT) converts the database schema to the target engine. AWS Database Migration Service (DMS) migrates the data while minimizing downtime. This approach provides a managed, reliable method fo
Question
A company is planning to migrate its business-critical applications from an on-premises data center to AWS. The company has an on-premises installation of a Microsoft SQL Server Always On cluster. The company wants to migrate to an AWS managed database service. A solutions architect must design a heterogeneous database migration on AWS. Which solution will meet these requirements?
Options
- AMigrate the SQL Server databases to Amazon RDS for MySQL by using backup and restore
- BUse an AWS Snowball Edge Storage Optimized device to transfer data to Amazon S3. Set up
- CUse AWS Schema Conversion Tool (AWS SCT) to translate the database schema to Amazon
- DUse AWS DataSync to migrate data over the network between on-premises storage and Amazon
Explanation
For a heterogeneous database migration (SQL Server to MySQL), AWS Schema Conversion Tool (SCT) converts the database schema to the target engine. AWS Database Migration Service (DMS) migrates the data while minimizing downtime. This approach provides a managed, reliable method for migrating business-critical applications to Amazon RDS for MySQL.
Community Discussion
No community discussion yet for this question.