Amazon Web Services AWS Certified Solutions Architect - Professional SAP-C02 Question # 194 Topic 20 Discussion
SAP-C02 Exam Topic 20 Question 194 Discussion:
Question #: 194
Topic #: 20
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