AWS Certified Database – Specialty — Question 195

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?

Answer options

• A. Export AWS DMS logs to Amazon CloudWatch and identify the DDL statement from the AWS Management Console
• B. Turn on logging for the AWS DMS task by setting the TARGET_LOAD action with the level of severity set to LOGGER_SEVERITY_DETAILED_DEBUG
• C. Turn on DDL activity tracing in the RDS for Oracle DB instance parameter group
• D. Turn on logging for the AWS DMS task by setting the TARGET_APPLY action with the level of severity' set to LOGGER_SEVERITY_DETAILED_DEBUG

Correct answer: D

Explanation

The correct answer is D because setting the TARGET_APPLY action with LOGGER_SEVERITY_DETAILED_DEBUG allows for detailed logging of the DDL statements being applied during the migration, which can help pinpoint the cause of the failure. Option A does not provide specific insights into the DDL issue, while option B focuses on the wrong action (TARGET_LOAD), and option C does not directly relate to the AWS DMS task's logging for the ongoing migration process.