nerdexam
Amazon

SAP-C02 · Question #796

A company needs to migrate some Oracle databases to AWSwhile keeping others on-premises for compliance. The on-prem databases contains patial data and run cron jobs. The solution must allow querying o

The correct answer is D. Use RDS for PostgreSQL with DMS and SCT. Use PostgreSQL foreign data wrappers. Connect. This solution uses AWS DMS and SCT to re-platform Oracle to RDS PostgreSQL, which supports Foreign Data Wrappers for querying on-premises Oracle databases as foreign tables, along with PostGIS for spatial data.

Submitted by amina.ke· Mar 6, 2026Migrate Workloads and Modernize Solutions

Question

A company needs to migrate some Oracle databases to AWSwhile keeping others on-premises for compliance. The on-prem databases contains patial data and run cron jobs. The solution must allow querying on-prem data as foreign tables from AWS. Which solution meets these requirements?

Options

  • AUse DynamoDB, SCT, and Lambda. Move spatial data to S3 and query with Athena.
  • BUse RDS for SQL Server and AWS Glue crawlers for Oracle access.
  • CUse EC2-hosted Oracle with Application Migration Service. Use Step Functions for cron.
  • DUse RDS for PostgreSQL with DMS and SCT. Use PostgreSQL foreign data wrappers. Connect

How the community answered

(21 responses)
  • A
    14% (3)
  • B
    5% (1)
  • C
    5% (1)
  • D
    76% (16)

Why each option

This solution uses AWS DMS and SCT to re-platform Oracle to RDS PostgreSQL, which supports Foreign Data Wrappers for querying on-premises Oracle databases as foreign tables, along with PostGIS for spatial data.

AUse DynamoDB, SCT, and Lambda. Move spatial data to S3 and query with Athena.

DynamoDB is a NoSQL database and not a suitable direct migration target for a relational Oracle database, especially with the requirement for querying on-prem data as foreign tables.

BUse RDS for SQL Server and AWS Glue crawlers for Oracle access.

AWS Glue crawlers are primarily for cataloging data sources for analytics, not for direct, live querying of on-premises Oracle data as foreign tables from an RDS instance.

CUse EC2-hosted Oracle with Application Migration Service. Use Step Functions for cron.

Using EC2-hosted Oracle is not a fully managed database service, and AWS Application Migration Service is for lift-and-shift, neither of which directly addresses the requirement for querying on-prem data as foreign tables from a managed AWS database.

DUse RDS for PostgreSQL with DMS and SCT. Use PostgreSQL foreign data wrappers. ConnectCorrect

Migrating to RDS for PostgreSQL using DMS and SCT supports the required re-platforming, while PostgreSQL's Foreign Data Wrappers (FDW) specifically allow querying on-premises Oracle data as foreign tables from AWS, and PostGIS handles spatial data.

Concept tested: Hybrid database migration, Oracle to PostgreSQL re-platforming, and Foreign Data Wrappers

Source: https://aws.amazon.com/blogs/database/query-on-premises-oracle-databases-from-amazon-rds-for-postgresql-using-oracle_fdw/

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full SAP-C02 Practice