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?
The company needs a solution to migrate Oracle databases to AWS while maintaining some databases on-premises for compliance. It also requires querying on-premises data from AWS and managing spatial data with cron jobs for maintenance. Creating an Amazon RDS for PostgreSQL DB instance meets these requirements effectively. PostgreSQL has native support for spatial data and can run cron jobs for maintenance. Using the AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS) enables a smooth migration from on-premises to AWS. AWS Direct Connect ensures a reliable and secure connection between the AWS environment and on-premises systems, allowing querying of foreign tables.
Option D is the most appropriate because it leverages AWS services effectively to migrate and manage the databases while ensuring compatibility with spatial data types and maintaining connectivity for querying on-premises data.
Option D is the most appropriate because it leverages AWS services effectively to migrate and manage the databases while ensuring compatibility with spatial data types and maintaining connectivity for querying on-premises data.
It's Data Migration Service that provides real-time bidirectional change data capture (CDC) synchronization
PostgreSQL has native support for spatial data, which is required by the company, so answer for me is D