SNOW-CSA Reporting, SLA and Imports Practice Question
Exhibit
Refer to the exhibit.
```json
{
"transform_action": "insert",
"target_table": "incident",
"field_map": [
{"source_field": "short_desc", "target_field": "short_description"}
]
}
```The JSON above shows part of a transform map configuration. What will happen when an import set row containing a value in the 'short_desc' field is processed?
⚠ Common exam trap
ServiceNow often tests the misconception that any import set row with a value will always create a new record, but the trap here is that the coalesce setting on a key field (like 'number') causes an update to an existing record instead, which candidates overlook.
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
✓
An existing incident record is updated with the short_description
The transform map configuration shown in the JSON includes a field mapping where 'short_desc' from the import set row is mapped to 'short_description' on the Incident table. When an import set row contains a value in 'short_desc', the transform engine will use the coalesce setting (if enabled) to match an existing incident record based on a unique identifier (e.g., number or sys_id). If a match is found, the existing incident is updated with the new short_description value; otherwise, a new incident would be created. Since the question implies the coalesce is set to true (common in such configurations), the correct behavior is an update to an existing incident record.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
A task record is created instead
Why it's wrong here
The mapping is to the Incident table, not Task, so no task record is created.
- ✗
The import fails because the target field name is incorrect
Why it's wrong here
The target field name 'short_description' is correct for the Incident table, so the import does not fail for that reason.
- ✓
An existing incident record is updated with the short_description
Why this is correct
With coalescing enabled on a key field like 'number', the import set row updates an existing incident record that matches the key, including the short_description field.
- ✗
A new incident record is created with the short_description populated
Why it's wrong here
New record creation only occurs if no matching record is found via coalescing; the question's configuration implies coalescing is set to update existing records.
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.