SNOW-CAD Integrating and managing application data Practice Question
A company is using an Import Set to load data from a CSV file into the Incident table. The CSV contains a column "Assigned to" with user names (e.g., "John Doe"). The transform map maps the "Assigned to" column to the "assigned_to" field on the Incident table. The import set runs successfully but the "assigned_to" field remains empty. What is the most likely cause?
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 transform map's field mapping uses "Reference" type but the "Display value" checkbox is not selected.
When mapping to a reference field using display value, the "Display value" checkbox must be selected in the field mapping. Without it, ServiceNow attempts to map the value as a sys_id, which fails silently, leaving the field empty.
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 transform map's field mapping uses "Direct" type instead of "Reference" type.
Why it's wrong here
While using "Direct" type may also cause issues, the default mapping type for reference fields is "Reference", and the most common mistake is forgetting to check "Display value".
- ✓
The transform map's field mapping uses "Reference" type but the "Display value" checkbox is not selected.
Why this is correct
For reference fields, when mapping with a non-sys_id value (like a name), the "Display value" checkbox must be selected to resolve the value to the correct sys_id.
- ✗
The transform map is set to "Create and Update" but the "Coalesce" field is not set.
Why it's wrong here
Coalesce is used for deduplication and does not affect field population.
- ✗
The "Assigned to" column header contains a space.
Why it's wrong here
Column headers can contain spaces; the mapping uses the exact header name, so this is not an issue.
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.