Exam CIS-SAM topic 2 question 28 discussion

The right answer is A: Reject to not create a record, if "ignore" is selected, the record will still me created. create: Create a new choice or record in the reference table. ignore: Ignore the new value from the source table. reject: Skip the entire row (record) containing the new value and continue to the next row.

The question is not clear about what record should not be created as in this scenario the transform would be creating two records, not one. There are two possibilities: - If the transforms target record should not be created, then Reject is the correct answer as this will stop the creation of the new choice or reference data and also block the insert of the target record - If the target choice or reference records should not be created, then Ignore would be a more appropriate option. This would allow the insert of the target record but block the insert of the new choice/reference data and leave the associated field on the target record empty. Reject would also work here but that would be throwing the baby out with the bath water. Delete is not a valid choice and Create is the happy path where you want to insert the related record

A. Reject will skip the record. Ignore will create a record, but leave the field empty or filled with default value.

Correct Answer D Ignore, ignores the value Reject, rejects the whole row

it should be ignore