SNOW-CSA Reporting, SLA and Imports Practice Question
After importing data, some records show as 'Ignored' in the import log. What is the most likely cause?
⚠ Common exam trap
Test-takers frequently confuse 'Ignored' with 'Skipped' or 'Error', not realizing that 'Ignored' specifically results from a coalesce match combined with an 'Insert only' action, rather than from field-level issues or condition failures.
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
✓
Coalesce matched an existing record and the transform map action is 'Insert only'.
When a transform map uses the 'Insert only' action and the Coalesce function finds a match on the source and target fields, the import engine ignores the record to prevent duplicates. This is a standard behavior in ServiceNow where coalesce is used to identify existing records, and if the action is set to 'Insert only', no update occurs, resulting in an 'Ignored' status in the import log.
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 field was empty and the target field is optional.
Why it's wrong here
Empty source fields are imported as null, and optional fields do not cause an ignore.
- ✗
A field mapping script returned null for a mandatory target field.
Why it's wrong here
This would typically cause an error, not an 'ignored' status.
- ✓
Coalesce matched an existing record and the transform map action is 'Insert only'.
Why this is correct
If the action is 'Insert only' and coalesce finds a matching record, the row is ignored to avoid duplicate insertion.
- ✗
The transform map condition evaluated to false.
Why it's wrong here
A false condition results in the row being skipped, which shows as 'Skipped' in the log, not 'Ignored'.
Go deeper
Related to this question
About these practice questions
This SNOW-CSA question is part of Courseiva's 504-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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-CSA 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-CSA exam.