ServiceNow CSA free question 8 / 10 · Domain 5: Database Management and Platform Security
Which two statements about the coalesce setting on transform map field maps are correct? (Choose two.)
- With no coalesce defined, all imported rows are treated as new records
- When a matching existing record is found, it is deleted and replaced by a new record
- With multiple-field coalesce, a record is updated when the values in all coalesce fields match
- When several existing records match the coalesce fields, each matching record is updated
Show the answer and explanation
Answer: A, C
Why this is correct
The documentation states that if no coalesce is defined, all imported rows are treated as new records and no existing records are updated. With multiple-field coalesce, a target record is updated when it has the same values in all coalesce fields as the staging table record; all coalesce field values must match.
Why the other options are wrong
"When several existing records match the coalesce fields, each matching record is updated" … The documentation does not update every matching record. It says to coalesce only on fields that will have unique values.
"When a matching existing record is found, it is deleted and replaced by a new record" … Nothing is deleted. If a record with a matching value is found, that record is updated; if no match is found, a new record is created.
Key point
Coalesce is what keeps repeated imports from creating duplicates. Choose coalesce fields that hold unique values, or an unintended record may be updated.
Go to the ServiceNow CSA practice app (10 free questions; purchase unlocks all questions)