nerdexam
Amazon

DBS-C01 · Question #291

A database administrator is working on transferring data from an on-premises Oracle instance to an Amazon RDS for Oracle DB instance through an AWS Database Migration Service (AWS DMS) task with ongoi

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

Submitted by krish.m· Mar 6, 2026Monitoring and Troubleshooting

Question

A database administrator is working on transferring data from an on-premises Oracle instance to an Amazon RDS for Oracle DB instance through an AWS Database Migration Service (AWS DMS) task with ongoing replication only. The database administrator noticed that the migration task failed after running successfully for some time. The logs indicate that there was generic error. The database administrator wants to know which data definition language (DDL) statement caused this issue. What should the database administrator do to identify' this issue in the MOST operationally efficient manner?

Options

  • AExport AWS DMS logs to Amazon CloudWatch and identify the DDL statement from the AWS
  • BTurn on logging for the AWS DMS task by setting the TARGET_LOAD action with the level of
  • CTurn on DDL activity tracing in the RDS for Oracle DB instance parameter group
  • DTurn on logging for the AWS DMS task by setting the TARGET_APPLY action with the level of

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

#AWS DMS#ongoing replication#DDL statements#error troubleshooting
Full DBS-C01 Practice