CLF-C02 Question 198
Select 2Your company is planning to migrate its on-premises database to AWS. The database structure is highly complex and includes proprietary stored procedures that are not natively supported by the target database engine on AWS. Which combination of tools should you use to ensure a successful migration?
- A
AWS Database Migration Service (AWS DMS)
- B
AWS Schema Conversion Tool (AWS SCT)
- C
AWS Snowball
- D
Amazon RDS Automated Backups
- E
AWS CloudFormation
Show answer and explanation
Correct answers: A, B
Explanation
Migrating a complex database to AWS typically requires both AWS DMS and AWS SCT. AWS DMS handles the actual data migration with minimal downtime, while AWS SCT converts the schema and proprietary database features to ensure compatibility with the target database engine. These tools work together to simplify and streamline the migration process.
- A. Correct.
AWS DMS is used to migrate data from one database to another with minimal downtime but does not handle schema conversion for complex proprietary features.
- B. Correct.
AWS SCT helps convert database schemas and proprietary features to be compatible with the target database engine, making it essential for complex migrations.
- C. Incorrect.
AWS Snowball is a physical data transfer device and is not designed for database migrations involving schema conversion or replication.
- D. Incorrect.
Amazon RDS Automated Backups are used for restoring databases but are not migration tools.
- E. Incorrect.
AWS CloudFormation is an infrastructure-as-code tool for managing AWS resources and is unrelated to database migration.