Amazon Web Services AWS Certified Solutions Architect - Professional SAP-C02 Question # 114 Topic 12 Discussion
SAP-C02 Exam Topic 12 Question 114 Discussion:
Question #: 114
Topic #: 12
Question:
A company needs to migratesome Oracle databases to AWSwhile keeping otherson-premisesfor compliance. The on-prem databases containspatial dataand runcron jobs. The solution must allowquerying on-prem data as foreign tablesfrom AWS.
A.
Use DynamoDB, SCT, and Lambda. Move spatial data to S3 and query with Athena.
B.
Use RDS for SQL Server and AWS Glue crawlers for Oracle access.
C.
Use EC2-hosted Oracle with Application Migration Service. Use Step Functions for cron.
D.
Use RDS for PostgreSQL with DMS and SCT. Use PostgreSQL foreign data wrappers. Connectvia Direct Connect.
D is correct becauseRDS for PostgreSQLsupportsforeign data wrappers (FDW)that allow querying remote Oracle databases. WithAWS Schema Conversion Tool (SCT)andDatabase Migration Service (DMS), schema and data can be migrated effectively.AWS Direct Connectensures secure, private connectivity to on-prem databases. Cron jobs can be run via EventBridge or external orchestration.
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit