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…
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.
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)- A14% (3)
- B5% (1)
- C5% (1)
- D76% (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.
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.
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.
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.
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.