- A
The import fails because the 'manufacturer' field is not mapped
Why wrong: Unmapped fields are not imported but do not cause failure.
- B
The 'name' field contains 'Laptop123, SN-12345' and 'serial_number' contains 'SN-12345'
Co-paste for 'name' concatenates source 'name' and source 'serial_number' (original), and the script for 'serial_number' transforms its own value.
- C
The 'name' field contains 'Laptop123, 12345' because the script for 'serial_number' overrides the co-paste for 'name'
Why wrong: Scripts run per target field; co-paste for 'name' uses source values, not the script output for 'serial_number'.
- D
The 'serial_number' field remains '12345' because the co-paste mapping for 'name' consumed the source field
Why wrong: Source fields are not consumed; they are available for multiple mappings.
Quick Answer
The answer is that the 'name' field contains 'Laptop123, SN-12345' and 'serial_number' contains 'SN-12345'. This outcome is correct because the transform map field mapping behavior for 'name' uses a co-paste of the source 'name' and 'serial_number' values, which concatenates them with a comma and space, while the mapping for 'serial_number' applies a script that prepends the 'SN-' prefix to the source value. The unmapped 'manufacturer' field is simply ignored during the import, as ServiceNow's import set transform map logic does not require every source field to be mapped—missing mappings cause no error or failure. On the CSA exam, this scenario tests your understanding of how co-paste, scripting, and unmapped fields interact within a transform map, a common trap being the assumption that an unmapped field will break the import. Remember the memory tip: co-paste joins with a comma-space, scripts override, and unmapped fields vanish without a trace.
SNOW-CSA Reporting, SLA and Imports Practice Question
This SNOW-CSA practice question tests your understanding of reporting, sla and imports. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
An administrator imports data from a CSV file into the 'cmdb_ci' table using a transform map. The import set row contains fields 'name', 'serial_number', and 'manufacturer'. The transform map has a field mapping for 'name' with a co-paste of 'name' and 'serial_number'. Another mapping for 'serial_number' uses a script to concatenate 'SN-' prefix. The 'manufacturer' field is not mapped. After the import, the resulting 'name' field contains 'Laptop123, SN-12345' and 'serial_number' contains 'SN-12345'. Which statement best describes the outcome?
Clue words in this question
Noticing these words before you look at the options changes how you read each choice.
Clue:
"best"Why it matters: Signals that multiple options may be partially correct. Choose the option that most directly solves the exact problem described, not the one that sounds most complete.
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 'name' field contains 'Laptop123, SN-12345' and 'serial_number' contains 'SN-12345'
The transform map's field mapping for 'name' uses a co-paste of 'name' and 'serial_number', which concatenates the source values with a comma and space, resulting in 'Laptop123, SN-12345'. The mapping for 'serial_number' uses a script that adds the 'SN-' prefix to the source 'serial_number' value, producing 'SN-12345'. The unmapped 'manufacturer' field is simply ignored during import, causing no failure. Therefore, the outcome matches option B exactly.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
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 import fails because the 'manufacturer' field is not mapped
Why it's wrong here
Unmapped fields are not imported but do not cause failure.
- ✓
The 'name' field contains 'Laptop123, SN-12345' and 'serial_number' contains 'SN-12345'
Why this is correct
Co-paste for 'name' concatenates source 'name' and source 'serial_number' (original), and the script for 'serial_number' transforms its own value.
Clue confirmation
The clue word "best" in the question point toward this answer.
Related concept
Read the scenario before looking for a memorised answer.
- ✗
The 'name' field contains 'Laptop123, 12345' because the script for 'serial_number' overrides the co-paste for 'name'
Why it's wrong here
Scripts run per target field; co-paste for 'name' uses source values, not the script output for 'serial_number'.
- ✗
The 'serial_number' field remains '12345' because the co-paste mapping for 'name' consumed the source field
Why it's wrong here
Source fields are not consumed; they are available for multiple mappings.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates mistakenly believe unmapped fields cause import failures or that field mappings consume source values, preventing other mappings from using them, when in fact each mapping reads independently from the source row.
Trap categories for this question
Command / output trap
Scripts run per target field; co-paste for 'name' uses source values, not the script output for 'serial_number'.
Detailed technical explanation
How to think about this question
In ServiceNow, a co-paste field mapping concatenates multiple source field values into one target field using a comma and space by default, but does not alter the source row. The script in the 'serial_number' mapping runs after the co-paste, using the original source value (e.g., '12345') to produce 'SN-12345'. Unmapped fields are simply ignored; the import engine only processes defined mappings, and any missing mappings do not trigger errors unless a mandatory field is unmapped and the table has a required attribute.
KKey Concepts to Remember
- Read the scenario before looking for a memorised answer.
- Find the constraint that changes the correct option.
- Eliminate answers that are true in general but not in this case.
TExam Day Tips
- Watch for words such as best, first, most likely and least administrative effort.
- Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
A small business has 20 workstations on the 192.168.1.0/24 network and one public IP from its ISP. The router uses PAT (NAT overload) so all 20 devices share one public address using different source ports. NAT questions test whether you understand the four address terms and which direction each translation applies.
What to study next
Got this wrong? Here's your next step.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
- →
Reporting, SLA and Imports — study guide chapter
Learn the concepts, then practise the questions
- →
Reporting, SLA and Imports practice questions
Targeted practice on this topic area only
- →
All SNOW-CSA questions
510 questions across all exam domains
- →
ServiceNow Certified System Administrator CSA study guide
Full concept coverage aligned to exam objectives
- →
SNOW-CSA practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Related SNOW-CSA practice-question pages
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Reporting, SLA and Imports practice questions
Practise SNOW-CSA questions linked to Reporting, SLA and Imports.
Self-Service and Automation practice questions
Practise SNOW-CSA questions linked to Self-Service and Automation.
UI, Navigation and Forms practice questions
Practise SNOW-CSA questions linked to UI, Navigation and Forms.
Database Administration and CMDB practice questions
Practise SNOW-CSA questions linked to Database Administration and CMDB.
Service Catalog and Workflows practice questions
Practise SNOW-CSA questions linked to Service Catalog and Workflows.
Application Rules, ACL and Notifications practice questions
Practise SNOW-CSA questions linked to Application Rules, ACL and Notifications.
SNOW-CSA fundamentals practice questions
Practise SNOW-CSA questions linked to SNOW-CSA fundamentals.
SNOW-CSA scenario practice questions
Practise SNOW-CSA questions linked to SNOW-CSA scenario.
SNOW-CSA troubleshooting practice questions
Practise SNOW-CSA questions linked to SNOW-CSA troubleshooting.
Practice this exam
Start a free SNOW-CSA practice session
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Questions learners often ask
What does this SNOW-CSA question test?
Reporting, SLA and Imports — This question tests Reporting, SLA and Imports — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: The 'name' field contains 'Laptop123, SN-12345' and 'serial_number' contains 'SN-12345' — The transform map's field mapping for 'name' uses a co-paste of 'name' and 'serial_number', which concatenates the source values with a comma and space, resulting in 'Laptop123, SN-12345'. The mapping for 'serial_number' uses a script that adds the 'SN-' prefix to the source 'serial_number' value, producing 'SN-12345'. The unmapped 'manufacturer' field is simply ignored during import, causing no failure. Therefore, the outcome matches option B exactly.
What should I do if I get this SNOW-CSA question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Are there clue words in this question I should notice?
Yes — watch for: "best". Signals that multiple options may be partially correct. Choose the option that most directly solves the exact problem described, not the one that sounds most complete.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
3 more ways this is tested on SNOW-CSA
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. An administrator is troubleshooting an import that is failing silently. The import set rows show 'Processed' with no errors, but no records are created or updated in the target table. Which THREE areas should the admin investigate?
hard- ✓ A.Check if the coalescing field is set correctly in the transform map.
- B.Check if the target table has a 'sys_id' field.
- ✓ C.Check if the field mappings are complete and correct.
- D.Check if the import set table is set as the target table.
- ✓ E.Check if there is a transform script that conditionally skips record creation.
Why A: Option A is correct because the coalescing field in the transform map determines how ServiceNow matches incoming records to existing records in the target table. If the coalescing field is misconfigured or missing, the import may appear to process successfully (rows show 'Processed') but no records are created or updated because the system cannot identify which records to insert or update, leading to a silent failure.
Variation 2. A company frequently imports data from an external HR system into the Employee [hr_employee] table using an import set. The import set runs nightly and maps fields correctly. Recently, the import started failing with the error 'Field 'manager' not found in table 'hr_employee''. The manager field exists in the import set rows but not in the target table. What is the most likely cause?
easy- ✓ A.The transform map has a field mapping that references 'manager' as a target field, but the hr_employee table does not have a 'manager' column.
- B.The import set row table (sys_import_set_row) does not have a 'manager' column.
- C.The source CSV file contains a column named 'manager' that is misspelled.
- D.The manager field in the target table is of a different data type (e.g., string vs reference).
Why A: The error 'Field 'manager' not found in table 'hr_employee'' indicates that the transform map is attempting to map a source field to a target column that does not exist in the hr_employee table. Since the import set rows contain the 'manager' field, the mapping in the transform map must be referencing 'manager' as a target field, but the target table lacks that column. This is the most likely cause because the transform map defines the field-to-field mapping between the import set row and the target table, and if the target field name is incorrect or missing from the table, the import will fail.
Variation 3. A company needs to import data from a CSV file into the User table. The CSV includes fields for first name, last name, email, and department. However, the import fails because some email addresses are invalid. Which feature in ServiceNow can be used to prevent invalid emails from being imported?
easy- A.Data Source configuration
- B.Import Set Row
- ✓ C.Transform Map with condition scripts
- D.Import Set Table API
Why C: Option C is correct because a Transform Map with condition scripts allows you to validate incoming data before it is written to the target table. In this scenario, you can add a script to the transform map that checks each email address against a regular expression pattern (e.g., RFC 5322) and skips or rejects rows with invalid emails, preventing them from being imported into the User table.
Last reviewed: Jun 11, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.