CLF-C02 · Question #144
Which combination of AWS services can be used to move a commercial relational database to an Amazon-managed open-source database? (Choose two.)
The correct answer is A. AWS Database Migration Service (AWS DMS) C. AWS Schema Conversion Tool. Migrating a Commercial Database to AWS Open-Source AWS Database Migration Service (DMS) handles the actual data movement, continuously replicating records from your source database (e.g., Oracle, SQL Server) to a target Amazon-managed open-source database (e.g., Aurora PostgreSQL
Question
Which combination of AWS services can be used to move a commercial relational database to an Amazon-managed open-source database? (Choose two.)
Options
- AAWS Database Migration Service (AWS DMS)
- BAWS software development kits (SDKs)
- CAWS Schema Conversion Tool
- DAWS Systems Manager
- EAmazon EMR
How the community answered
(44 responses)- A75% (33)
- B16% (7)
- D5% (2)
- E5% (2)
Explanation
Migrating a Commercial Database to AWS Open-Source
AWS Database Migration Service (DMS) handles the actual data movement, continuously replicating records from your source database (e.g., Oracle, SQL Server) to a target Amazon-managed open-source database (e.g., Aurora PostgreSQL, MySQL). AWS Schema Conversion Tool (SCT) complements DMS by converting the database schema, stored procedures, and code objects from the proprietary format to the open-source equivalent before migration begins - together, they cover both structure and data.
The distractors fall short because:
- SDKs (B) are programming toolkits for building applications, not migration utilities
- Systems Manager (D) manages infrastructure and operational tasks, not database migrations
- Amazon EMR (E) is a big data/analytics platform (Hadoop, Spark), unrelated to relational database migrations
Memory Tip: Think of the migration as a two-step move - SCT = "Pack the boxes" (convert the schema/structure) and DMS = "Drive the truck" (move the actual data). You need both tools to complete a full commercial-to-open-source database migration successfully.
Topics
Community Discussion
No community discussion yet for this question.