SNOW-CAD Working with Data Practice Question
An organization uses a scheduled data import to load incident data from an external system into ServiceNow. The import set runs successfully, but the transform map sometimes fails to update certain records because the unique key field (sys_id) from the source does not match the sys_id in ServiceNow due to a different format. The team wants to update existing records based on a custom 'external_id' field in the incident table, which is guaranteed to be unique and correctly populated from the source. The target table already has a unique index on 'external_id'. Which configuration should the developer implement to achieve reliable updates?
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
✓
Create a new transform map with coalesce on the 'external_id' field and map the source field to incident.external_id.
By creating a new transform map with coalesce on the 'external_id' field, the system will use the 'external_id' value from the source to match existing records in the incident table. Since a unique index exists on 'external_id', this ensures reliable updates. Option A is incorrect because a database view does not affect import matching logic. Option B is wrong because coalesce on 'sys_id' would fail due to format differences. Option D does not address the matching issue—increasing frequency does not improve record matching.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a database view to join the import set and incident table on the external_id field.
Why it's wrong here
Incorrect: A database view is read-only and does not perform data imports or updates.
- ✗
Modify the existing transform map to use 'update' action and set coalesce on the sys_id field.
Why it's wrong here
Incorrect: The sys_id formats differ, so coalesce on sys_id would not match records.
- ✓
Create a new transform map with coalesce on the 'external_id' field and map the source field to incident.external_id.
Why this is correct
Correct: Coalesce on 'external_id' enables matching and updating existing records based on that unique field.
- ✗
Increase the scheduled import frequency to overwrite the records.
Why it's wrong here
Incorrect: This does not fix the matching problem; it would just run more often with the same issue.
Go deeper
Related to this question
About these practice questions
One of 481 original SNOW-CAD practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
1 more way this is tested on SNOW-CAD
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. Refer to the exhibit. A transform map configuration is shown. What will happen if the source data has a 'u_model_id' value that matches an existing record in the 'cmdb_ci_model' table?
easy- A.The transform will ignore the field because it is already mapped.
- B.The transform will create a new model record with the given value.
- ✓ C.The transform will automatically set the model_id reference to the existing model record.
- D.The transform will skip the record because the model already exists.
Why C: When coalesce is set to true on a reference field like 'model_id', the transform engine uses the source value (u_model_id) to look up an existing record in the referenced table (cmdb_ci_model). If a matching record is found, the transform sets the reference field to that existing record without creating a new one. Option A is incorrect because coalesce does not ignore the field; it actively searches for a matching record. Option B is incorrect because coalesce does not create new records; it only matches existing ones. Option D is incorrect because the transform does not skip the record; it proceeds with the transformation, setting the reference to the existing model.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SNOW-CAD 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-CAD exam.