ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 282 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 282
Topic #: 1
[All AWS Certified Database - Specialty Questions]

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?

  • 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
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by Sab at Dec. 1, 2022, 3:03 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Sab
Highly Voted 2 years, 5 months ago
Answer D https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TaskSettings.Logging.html
upvoted 5 times
...
MultiAZ
Most Recent 1 year, 3 months ago
Selected Answer: D
D TARGET_APPLY is for CDC. The question mentions the DMS task is CDC only. TARGE_LOAD is for the initial load
upvoted 1 times
...
Kodoma
1 year, 11 months ago
Selected Answer: D
TARGET_APPLY – Data and data definition language (DDL) statements are applied to the target database. (correct) TARGET_LOAD – Data is loaded into the target database.
upvoted 4 times
...
khun
2 years, 4 months ago
D. TARGET_APPLY – Data and data definition language (DDL) statements are applied to the target database. LOGGER_SEVERITY_DETAILED_DEBUG – All information is written to the log.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago