nerdexam
AmazonAmazon

DBS-C01 · Question #292

DBS-C01 Question #292: Real Exam Question with Answer & Explanation

Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #292. The question stem and answer options stay visible for context.

Submitted by helene.fr· Mar 6, 2026Deployment and Migration

Question

A company is migrating its 200 GB on-premises PostgreSQL database to Amazon Aurora PostgreSQL. The original database columns include NOT NULL and foreign key constraints. A database administrator needs to complete the migration while following best practices for database migrations. Which option meets these requirements to migrate the database to AWS?

Options

  • AUse the AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS
  • BCreate an AWS Lambda function to connect to the source database and load the data into the
  • CUse the PostgreSQL tools pg_dump and pg_restore to migrate to the Aurora PostgreSQL DB
  • DCreate an Aurora PostgreSQL read replica and promote the read replica to become primary once

Unlock DBS-C01 to see the answer

You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#PostgreSQL migration#Aurora PostgreSQL#pg_dump#pg_restore
Full DBS-C01 PracticeBrowse All DBS-C01 Questions