SNOW-CAD Working with Data Practice Question
Which TWO conditions must be met for a transform map to automatically ignore duplicate records during an import?
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
✓
The target table has a unique index on the coalesce field.
For duplicate detection to automatically ignore duplicate records already in the target table, two conditions must be met: the transform map must have 'Enable Duplicate Detection' set to true (option E), and the target table must have a unique index on the coalesce field (option B). The coalesce field mapping identifies the field used to check for duplicates; a unique index on the target table enforces uniqueness, allowing the system to detect that a record already exists. Options A, C, and D are incorrect: a unique index on the source table (A) is not required for target duplicate detection; the 'Ignore if Empty' checkbox (C) relates to handling empty values, not duplicate detection; and an index on the import set table (D) is used for detecting duplicates within the same import set, not for ignoring duplicates already in the target.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The source table has a unique index on the coalesce field.
Why it's wrong here
Incorrect: Source table indexing is not required for target duplicate detection.
- ✓
The target table has a unique index on the coalesce field.
Why this is correct
Correct: The target table must have a unique index on the coalesce field for the system to identify and ignore duplicate records.
- ✗
The coalesce field mapping uses the 'Ignore if Empty' checkbox.
Why it's wrong here
Incorrect: 'Ignore if Empty' controls whether empty values are considered for coalesce, but does not affect duplicate detection.
- ✗
The import set table has a unique index on the coalesce field.
Why it's wrong here
Incorrect: A unique index on the import set table is needed for detecting duplicates within the same import set, but not for ignoring duplicates already in the target.
- ✓
The transform map has 'Enable Duplicate Detection' set to true.
Why this is correct
Correct: This checkbox enables duplicate detection when a coalesce field mapping is set.
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.