SNOW-CSA Reporting, SLA and Imports Practice Question
Exhibit
Refer to the exhibit. [Import Set Row XML] <?xml version="1.0" encoding="UTF-8"?> <import_set_row> <source>csv_import</source> <staging_table>u_import_incident</staging_table> <field name="u_number">INC001</field> <field name="u_short_description">Server down</field> <field name="u_category">Infrastructure</field> <field name="u_assigned_to">admin</field> </import_set_row> [Transform Map Log] Transform started for source csv_import on table u_import_incident Field mapping: u_number -> number (coalesce true) Field mapping: u_short_description -> short_description Field mapping: u_category -> category (script) Script error: Cannot read property 'sys_id' of null Field mapping: u_assigned_to -> assigned_to (direct) Transform completed: 0 records created, 0 updated
Based on the exhibit, why did the transform create or update zero records?
⚠ Common exam trap
Candidates often assume a missing coalesce or table mismatch is the root cause of zero records, but this question tests the understanding that a transform script error can silently abort all row processing without producing a visible error message, unlike field-level mapping issues which only affect specific fields.
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 script on the category field has an error
The script on the category field contains an error that causes the transform to fail silently, resulting in zero records being created or updated. In ServiceNow, a transform script that throws an unhandled exception or returns an unexpected value (e.g., 'false' or 'skip') will abort the mapping for that row, and if it affects all rows, no records are processed. The exhibit likely shows a script that either has a syntax error or logic that prevents any row from passing through the transform map.
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 assigned_to field mapping is missing a coalesce
Why it's wrong here
Missing coalesce would cause inserts, not zero records.
- ✗
The staging table does not match the target table
Why it's wrong here
Staging table is u_import_incident, which exists.
- ✓
The script on the category field has an error
Why this is correct
The log shows script error, causing the row to skip.
- ✗
The coalesce field is set incorrectly
Why it's wrong here
Coalesce is set and should work, but error interferes.
Go deeper
Related to this question
About these practice questions
Courseiva writes every SNOW-CSA question from scratch — 504 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-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.