A company must move some on-premises Oracle databases to AWS but keep others on premises for compliance. The on-premises databases include spatial data and run cron jobs for maintenance. From AWS, the company needs to connect directly to on-premises systems and query on-premises data as foreign tables. Which architecture meets these requirements?

The correct option meets all requirements. Amazon RDS for PostgreSQL supports spatial data (PostGIS) and allows cron jobs for maintenance directly on the instance. AWS SCT and DMS facilitate migration from Oracle. AWS Direct Connect provides the necessary private, dedicated connection for querying on-premises data as foreign tables from RDS, ensuring secure and efficient hybrid connectivity. Incorrect options: DynamoDB is a NoSQL database and not suitable for direct Oracle migration with spatial data and foreign table requirements. RDS for SQL Server doesn't align with the Oracle source, and Redshift is an analytical data warehouse, not ideal for operational spatial data. AWS Glue crawlers are for cataloging, not direct foreign table access from an operational database. Migrating to EC2 instances for Oracle would require managing the OS and database, which RDS abstracts. Exposing connectivity via an Internet Gateway is insecure and doesn't provide the dedicated connection needed for foreign tables.