SNOW-CSA Reporting, SLA and Imports Practice Question
An administrator is troubleshooting an import that is failing silently. The import set rows show 'Processed' with no errors, but no records are created or updated in the target table. Which THREE areas should the admin investigate?
⚠ Common exam trap
ServiceNow often tests the misconception that 'Processed' status means records were successfully created or updated, when in fact it only indicates the transform map ran without throwing an error, not that data was committed to the target table.
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
✓
Check if the coalescing field is set correctly in the transform map.
The coalescing field in the transform map determines how ServiceNow matches incoming records to existing records in the target table. If the coalescing field is misconfigured or missing, the import may appear to process successfully (rows show 'Processed') but no records are created or updated because the system cannot identify which records to insert or update, leading to a silent failure.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Check if the coalescing field is set correctly in the transform map.
Why this is correct
If coalescing is set to a field that does not match, no updates may occur.
- ✗
Check if the target table has a 'sys_id' field.
Why it's wrong here
All tables have a sys_id field.
- ✓
Check if the field mappings are complete and correct.
Why this is correct
Missing mappings can result in empty records that may be filtered out.
- ✗
Check if the import set table is set as the target table.
Why it's wrong here
The import set table is the source, not the target.
- ✓
Check if there is a transform script that conditionally skips record creation.
Why this is correct
Transform scripts can prevent record creation if conditions are not met.
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.