AWS Certified Solutions Architect - Professional SAP-C02 — Topic 1 Question 497

Question

A company needs to move some on-premises Oracle databases to AWS. The company has chosen to keep some of the databases on premises for business compliance reasons. The on-premises databases contain spatial data and run cron jobs for maintenance. The company needs to connect to the on-premises systems directly from AWS to query data as a foreign table. Which solution will meet these requirements?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: Create an Amazon RDS for PostgreSQL DB instance. Use the AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS) to move the data from on premises to the DB instance. Use PostgreSQL native sp... Amazon RDS is a managed relational database that handles patching, backups and failover. AWS Direct Connect provides a dedicated, consistent private network link between on premises and AWS. AWS Database Migration Service migrates databases with minimal downtime.

AWS Certified Solutions Architect - Professional SAP-C02 — Question 497