SNOW-CSA Reporting, SLA and Imports Practice Question
A ServiceNow administrator is responsible for importing data from an external HR system into the Employee table. The import set uses a transform map that creates new records and updates existing ones based on the employee number. Recently, the administrator noticed that some existing records are being incorrectly duplicated. The transform map is configured with a coalesce on the 'Employee Number' field. After reviewing the import log, the administrator finds that the import set rows are being processed, but the coalesce is not matching correctly. The HR system sends data with employee numbers that have leading zeros, but the ServiceNow employee number field is stored without leading zeros. For example, employee number '0123' in the source is '123' in ServiceNow. The administrator needs to fix this issue without modifying the HR system data. Which course of action should the administrator take?
⚠ Common exam trap
The trap here is that candidates mistakenly think a business rule or field-level script can fix the coalesce matching, but the coalesce runs before those scripts, so only a transform map script executed before the coalesce can normalize the source value for correct matching.
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
✓
Add a script in the transform map to remove leading zeros from the employee number before the coalesce runs.
The coalesce operation in a transform map runs before field mapping scripts, so a script placed in the transform map's 'Script' field (or a 'Before' script) can normalize the source value by removing leading zeros before the coalesce attempts to match. This ensures the incoming '0123' is converted to '123' and correctly matches the existing record in the Employee table.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Modify the import set table to store employee numbers as strings with leading zeros.
Why it's wrong here
Changing the import set table does not affect the coalesce on the target table; the target still expects no leading zeros.
- ✓
Add a script in the transform map to remove leading zeros from the employee number before the coalesce runs.
Why this is correct
This normalizes the source value to match the target during the coalesce operation.
- ✗
Change the coalesce field to a different unique field such as email address.
Why it's wrong here
While email may be unique, it is not necessarily more reliable, and changing the coalesce field does not address the root cause of leading zeros.
- ✗
Use a before business rule on the Employee table to trim leading zeros on the employee number field.
Why it's wrong here
Business rules run after the database operation; the coalesce would have already failed before the record is created.
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.