SNOW-CSA Reporting, SLA and Imports Practice Question
An import set row is being transformed but the target record is not updated. Which two possible causes should the administrator investigate? (Choose two.)
⚠ Common exam trap
Test-takers frequently confuse the 'Coalesce' field with update logic, but coalesce only prevents empty import set values from overwriting existing data, not from preventing updates entirely.
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 'Action' field is set to 'Create' instead of 'Create or Update'.
The transform map's 'Action' field determines whether the import set row creates a new record or updates an existing one. If set to 'Create', the system will never attempt to update an existing target record, even if a matching record is found. Setting it to 'Create or Update' allows the transform to update the target record when a match exists.
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 staging table's 'Target table' field is set to the wrong table.
Why it's wrong here
This would cause the row to be transformed to a different table, not fail.
- ✓
The transform map's 'Action' field is set to 'Create' instead of 'Create or Update'.
Why this is correct
If action is 'Create', it will only create, not update.
- ✓
The transform script has a syntax error that prevents the update.
Why this is correct
A syntax error in the transform script will cause the transform to fail and the record not to be updated.
- ✗
The transform map has the 'Coalesce' field set but no matching record exists.
Why it's wrong here
This would typically create a new record, not fail the update.
- ✗
The import set row has a 'state' value that is invalid.
Why it's wrong here
Invalid state might cause a business rule error but not necessarily prevent the update.
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.