SAP-C02 · Question #759
A company needs to move some on-premises Oracle databases to AWS. The company has chosen to keep some of the databases on premises for business compliance reasons. The on-premises databases contain…
The correct answer is D. Create an Amazon RDS for PostgreSQL DB instance. Use the AWS Schema Conversion Tool. It's Data Migration Service that provides real-time bidirectional change data capture (CDC) synchronization.
Question
A company needs to move some on-premises Oracle databases to AWS. The company has chosen to keep some of the databases on premises for business compliance reasons. The on-premises databases contain spatial data and run cron jobs for maintenance. The company needs to connect to the on-premises systems directly from AWS to query data as a foreign table. Which solution will meet these requirements?
Options
- ACreate Amazon DynamoDB global tables with auto scaling enabled. Use the AWS Schema
- BCreate an Amazon RDS for Microsoft SQL Server DB instance. Use native replication to move
- CLaunch Amazon EC2 instances to host the Oracle databases. Place the EC2 instances in an Auto
- DCreate an Amazon RDS for PostgreSQL DB instance. Use the AWS Schema Conversion Tool
How the community answered
(41 responses)- A5% (2)
- B10% (4)
- C15% (6)
- D71% (29)
Explanation
It's Data Migration Service that provides real-time bidirectional change data capture (CDC) synchronization.
Community Discussion
No community discussion yet for this question.