SNOW-CAD Working with Data Practice Question
An import set is failing because some records have duplicate values in a unique field. The requirement is to skip duplicates and import only new records. Which transform map option should be used?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Enable 'Coalesce' on the unique field and set 'Action' to 'Insert' in the transform map.
Coalesce on the unique field allows the transform map to identify existing records by matching the incoming field to a unique field in the target table. Setting the Action to 'Insert' ensures that only new records are imported; if a match is found, the record is skipped (since it already exists). Option A ('Import set update only') is not a standard option in ServiceNow. Option B ('Update existing records') would update duplicates rather than skip them. Option C ('Reject duplicates') is not a typical option in data sources; the correct approach is using coalesce with Insert action.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Enable 'Import set update only' in the transform map.
Why it's wrong here
This option updates existing records but does not skip duplicates.
- ✗
Enable 'Update existing records' in the transform map.
Why it's wrong here
This would update duplicates instead of skipping them.
- ✗
Enable 'Reject duplicates' in the data source options.
Why it's wrong here
There is no such option in data sources.
- ✓
Enable 'Coalesce' on the unique field and set 'Action' to 'Insert' in the transform map.
Why this is correct
Coalesce identifies existing records, and setting action to Insert ensures new records are created and duplicates are ignored.
Go deeper
Related to this question
About these practice questions
Courseiva writes every SNOW-CAD question from scratch — 481 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SNOW-CAD practice question is part of Courseiva's free ServiceNow certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SNOW-CAD exam.