SNOW-CAD Creating and customizing tables and data Practice Question
A company uses an import set to bring in hardware asset data from an external inventory system. The staging table 'u_hardware_staging' maps fields to the 'alm_hardware' table via a transform map. Recently, the import set started failing with the error 'Invalid reference field value: 'PO123' for field 'purchase_order''. The 'purchase_order' field on 'alm_hardware' is a reference to the 'purchase_order' table, and the staging field contains the purchase order number (e.g., 'PO123'). The transform map has a field map that uses the 'Find' and 'Map' functionality to match the purchase order number. The 'purchase_order' table uses the 'number' field as the display value. Which change should the administrator make to fix the error?
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
✓
In the transform map, enable 'Find map for each record' and set the match field to 'number' on the purchase_order table
The transform map needs to find the purchase order record by its 'number' field (display value). Enabling 'Find map for each record' and setting the match field to 'number' on the purchase_order table allows the transform to resolve the reference. Option B is incorrect because the staging table should contain the number, not the sys_id, as the import source provides readable values. Option C is incorrect because using 'Direct' would attempt to set the reference field with the number string, which is invalid. Option D is incorrect because database views do not apply to transform mappings.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
In the transform map, enable 'Find map for each record' and set the match field to 'number' on the purchase_order table
Why this is correct
This configuration will use the number field to look up the corresponding sys_id and populate the reference field correctly.
- ✗
Modify the staging table to include the sys_id of the purchase order instead of the number
Why it's wrong here
The external system provides the purchase order number, not the sys_id. Changing the staging table does not solve the mapping issue.
- ✗
Change the field map to use 'Direct' instead of 'Find' and 'Map'
Why it's wrong here
Using 'Direct' would try to directly insert the value 'PO123' into the reference field, which expects a sys_id, not a number.
- ✗
Create a database view between the staging table and the purchase_order table to auto-populate the reference
Why it's wrong here
Database views are read-only and cannot be used to populate fields during import.
Visual reference
Go deeper
Related to this question
About these practice questions
Courseiva writes every SNOW-CAD question from scratch — 481 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-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.