ExpertMedium1 markMultiple Choice
AWS SAP-C02 · Question 18 · Domain 4.3: Migration Strategy
A company needs to migrate a 50 TB Oracle database to Amazon Aurora PostgreSQL. The migration must have minimal downtime. Which combination of tools should be used?
A company needs to migrate a 50 TB Oracle database to Amazon Aurora PostgreSQL. The migration must have minimal downtime. Which combination of tools should be used?
Answer options:
A.
AWS DataSync and AWS DMS
B.
AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS)
C.
AWS Snowball Edge and AWS SCT
D.
Native Oracle Data Guard
How to approach this question
Identify the tools required for heterogeneous database migration.
Full Answer
B.AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS)✓ Correct
AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS)
Heterogeneous migrations require SCT to convert the schema and DMS to perform the initial load and ongoing replication.
Common mistakes
Forgetting that DMS alone cannot convert schemas between different database engines.
Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 3
75 questions · hints · full answers · grading
More questions from this exam
Q01An enterprise has 100 VPCs across 5 AWS Regions. They need to establish a highly available, trans...HardQ02A company uses AWS Organizations. The CISO requires that no EC2 instances can be launched outside...MediumQ03An application uses Amazon Aurora PostgreSQL. To meet disaster recovery requirements, the databas...HardQ04A company is setting up a new multi-account AWS environment. They want to automate the creation o...MediumQ05An organization wants to allocate AWS costs to specific departments. They use multiple AWS accoun...Medium